Azure SQL Database gives you a robust datastore with the flexibility to scale to meet demand.
Get metrics from Azure SQL Database to:
If you haven’t already, set up the Microsoft Azure integration first. There are no other installation steps that need to be performed.
| azure.sql_servers_databases.active_queries (count) | Active queries across all workload groups. Applies only to data warehouses. Shown as query |
| azure.sql_servers_databases.app_cpu_billed (count) | App CPU billed. Applies to serverless databases. |
| azure.sql_servers_databases.app_cpu_percentage (gauge) | App CPU percentage. Applies to serverless databases. Shown as percent |
| azure.sql_servers_databases.app_memory_percentage (gauge) | App memory percentage. Applies to serverless databases. Shown as percent |
| azure.sql_servers_databases.base_blob_storage_size (gauge) | Base blob storage size. Applies to Hyperscale databases. Shown as byte |
| azure.sql_servers_databases.blocked_by_firewall (count) | Blocked by Firewall Shown as connection |
| azure.sql_servers_databases.cache_hit_percentage (gauge) | Cache hit percentage. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.cache_used_percentage (gauge) | Cache used percentage. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.connection_failed (count) | Failed Connections Shown as connection |
| azure.sql_servers_databases.connection_successful (count) | Successful Connections Shown as connection |
| azure.sql_servers_databases.cpu_limit (count) | CPU limit. Applies to vCore-based databases. |
| azure.sql_servers_databases.cpu_percent (gauge) | CPU percentage Shown as percent |
| azure.sql_servers_databases.cpu_percent.max (gauge) | Maximum CPU percentage (Max Aggregated) Shown as percent |
| azure.sql_servers_databases.cpu_used (count) | CPU used. Applies to vCore-based databases. |
| azure.sql_servers_databases.cpu_used.max (count) | Maximum CPU used. Applies to vCore-based databases. (Max Aggregated) |
| azure.sql_servers_databases.data_space_allocated (gauge) | Allocated data storage. Not applicable to data warehouses. Shown as byte |
| azure.sql_servers_databases.data_storage_size (count) | Data Storage Size is comprised of the size of your data and the transaction log. The metric is counted towards the 'Storage' portion of your bill. Applies only to data warehouses. |
| azure.sql_servers_databases.deadlock (count) | Deadlocks. Not applicable to data warehouses. |
| azure.sql_servers_databases.differential_backup_storage_size (gauge) | Cumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. Shown as byte |
| azure.sql_servers_databases.disaster_recovery_storage_size (count) | Disaster Recovery Storage Size is reflected as 'Disaster Recovery Storage' in your bill. Applies only to data warehouses. |
| azure.sql_servers_databases.dtu_consumption_percent (gauge) | DTU Percentage. Applies to DTU-based databases. Shown as percent |
| azure.sql_servers_databases.dtu_limit (count) | DTU Limit. Applies to DTU-based databases. Shown as unit |
| azure.sql_servers_databases.dtu_used (count) | DTU used. Applies to DTU-based databases. Shown as unit |
| azure.sql_servers_databases.dwu_consumption_percent (gauge) | DWU percentage. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.dwu_limit (count) | DWU limit. Applies only to data warehouses. Shown as unit |
| azure.sql_servers_databases.dwu_used (count) | DWU used. Applies only to data warehouses. Shown as unit |
| azure.sql_servers_databases.effective_cap_resource_percent (gauge) | A hard limit on the percentage of resources allowed for the workload group, taking into account Effective Min Resource Percentage allocated for other workload groups. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.effective_min_resource_percent (gauge) | Minimum percentage of resources reserved and isolated for the workload group, taking into account the service level minimum. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.full_backup_storage_size (gauge) | Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. Shown as byte |
| azure.sql_servers_databases.local_tempdb_percentage (gauge) | Local tempdb percentage. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.log_backup_storage_size (gauge) | Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases. Shown as byte |
| azure.sql_servers_databases.log_write_percent (gauge) | Log IO percentage. Not applicable to data warehouses. Shown as percent |
| azure.sql_servers_databases.memory_percentage (gauge) | Memory percentage. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.physical_data_read_percent (gauge) | Data IO percentage Shown as percent |
| azure.sql_servers_databases.physical_data_read_percent.max (gauge) | Maximum Data IO percentage (Max Aggregated) Shown as percent |
| azure.sql_servers_databases.queued_queries (count) | Queued queries across all workload groups. Applies only to data warehouses. Shown as query |
| azure.sql_servers_databases.replication_links.count (gauge) | The amount of replication links per database |
| azure.sql_servers_databases.sessions_percent (gauge) | Sessions percentage. Not applicable to data warehouses. Shown as percent |
| azure.sql_servers_databases.snapshot_backup_storage_size (gauge) | Cumulative snapshot backup storage size. Applies to Hyperscale databases. Shown as byte |
| azure.sql_servers_databases.snapshot_storage_size (count) | Snapshot Storage Size is the size of the incremental changes captured by snapshots to create user-defined and automatic restore points. The metric is counted towards the 'Storage' portion of your bill. Applies only to data warehouses. |
| azure.sql_servers_databases.sql_server_process_core_percent (gauge) | CPU usage percentage for the SQL Server process, as measured by the operating system. Shown as percent |
| azure.sql_servers_databases.sql_server_process_memory_percent (gauge) | Memory usage percentage for the SQL Server process, as measured by the operating system. Shown as percent |
| azure.sql_servers_databases.status (gauge) | Status of Azure SQL Database (deprecated) |
| azure.sql_servers_databases.storage (gauge) | Data space used. Not applicable to data warehouses. Shown as byte |
| azure.sql_servers_databases.storage_percent (gauge) | Data space used percent. Not applicable to data warehouses or hyperscale databases. Shown as percent |
| azure.sql_servers_databases.tempdb_data_file_size_kilobytes (count) | Tempdb Data File Size Kilobytes. |
| azure.sql_servers_databases.tempdb_log_file_size_kilobytes (count) | Tempdb Log File Size Kilobytes. |
| azure.sql_servers_databases.tempdb_percent_log_used (gauge) | Tempdb Percent Log Used. Shown as percent |
| azure.sql_servers_databases.workers_percent (gauge) | Workers percentage. Not applicable to data warehouses. Shown as percent |
| azure.sql_servers_databases.workload_group_active_queries (count) | Queued queries within the workload group. Applies only to data warehouses. Shown as query |
| azure.sql_servers_databases.workload_group_allocation_by_cap_resource_percent (gauge) | Allocated percentage of resources relative to the specified cap resources per workload group. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.workload_group_allocation_by_system_percent (gauge) | Allocated percentage of resources relative to the entire system per workload group. Applies only to data warehouses. Shown as percent |
| azure.sql_servers_databases.workload_group_query_timeouts (count) | Queries that have timed out for the workload group. Applies only to data warehouses. Shown as query |
| azure.sql_servers_databases.workload_group_queued_queries (count) | Active queries within the workload group. Applies only to data warehouses. Shown as query |
| azure.sql_servers_databases.xtp_storage_percent (gauge) | In-Memory OLTP storage percent. Not applicable to data warehouses. Shown as percent |
The Azure SQL Database integration does not include any events.
The Azure SQL Database integration does not include any service checks.
Need help? Contact Datadog support.
