Azure SQL Database monitoring data reference
This article contains all the monitoring reference information for this service.
See Monitor Azure SQL Database for details on the data you can collect for SQL Database and how to use it.
Metrics
This section lists all the automatically collected platform metrics for this service. These metrics are also part of the global list of all platform metrics supported in Azure Monitor.
For information on metric retention, see Azure Monitor Metrics overview.
For a list of commonly used metrics for Azure SQL Database, see Azure SQL Database metrics.
Supported metrics for Microsoft.Sql/servers/databases
The following table lists the metrics available for the Microsoft.Sql/servers/databases resource type.
- All columns might not be present in every table.
- Some columns might be beyond the viewing area of the page. Select Expand table to view all available columns.
Table headings
- Category - The metrics group or classification.
- Metric - The metric display name as it appears in the Azure portal.
- Name in REST API - The metric name as referred to in the REST API.
- Unit - Unit of measure.
- Aggregation - The default aggregation type. Valid values: Average (Avg), Minimum (Min), Maximum (Max), Total (Sum), Count.
- Dimensions - Dimensions available for the metric.
- Time Grains - Intervals at which the metric is sampled. For example,
PT1M
indicates that the metric is sampled every minute,PT30M
every 30 minutes,PT1H
every hour, and so on. - DS Export- Whether the metric is exportable to Azure Monitor Logs via diagnostic settings. For information on exporting metrics, see Create diagnostic settings in Azure Monitor.
Category: Basic
Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
---|---|---|---|---|---|---|
Active queries Active queries across all workload groups. Applies only to data warehouses. |
active_queries |
Count | Total (Sum) | <none> | PT1M | Yes |
Data space allocated Allocated data storage. Not applicable to data warehouses. |
allocated_data_storage |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
App CPU billed App CPU billed. Applies to serverless databases. |
app_cpu_billed |
Count | Total (Sum) | <none> | PT1M | Yes |
App CPU billed HA replicas Sum of app CPU billed across all HA replicas associated with the primary replica or a named replica. |
app_cpu_billed_ha_replicas |
Count | Total (Sum) | <none> | PT1M | Yes |
App CPU percentage App CPU percentage. Applies to serverless databases. |
app_cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
App memory percentage App memory percentage. Applies to serverless databases. |
app_memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Availability (Preview) The percentage of SLA compliant availability for the database. Availability is calculated based on connections and for each one-minute data point the value will be either 100% if connection(s) succeed or 0% if all connections fail due to system errors. Note: Select 1-minute time granularity to view SLA compliant availability. |
availability |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data storage size Data storage size. Applies to Hyperscale databases. |
base_blob_size_bytes |
Bytes | Average, Maximum, Minimum | <none> | P1D | Yes |
Blocked by Firewall Blocked by Firewall |
blocked_by_firewall |
Count | Total (Sum), Count | <none> | PT1M | Yes |
Cache hit percentage Cache hit percentage. Applies only to data warehouses. |
cache_hit_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Cache used percentage Cache used percentage. Applies only to data warehouses. |
cache_used_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Failed Connections : System Errors Failed Connections |
connection_failed |
Count | Total (Sum), Count | Error , ValidatedDriverNameAndVersion |
PT1M | Yes |
Failed Connections : User Errors Failed Connections : User Errors |
connection_failed_user_error |
Count | Total (Sum), Count | Error , ValidatedDriverNameAndVersion |
PT1M | Yes |
Successful Connections Successful Connections |
connection_successful |
Count | Total (Sum), Count | SslProtocol , ValidatedDriverNameAndVersion |
PT1M | Yes |
CPU limit CPU limit. Applies to vCore-based databases. |
cpu_limit |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
CPU percentage CPU percentage |
cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
CPU used CPU used. Applies to vCore-based databases. |
cpu_used |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Deadlocks Deadlocks. Not applicable to data warehouses. |
deadlock |
Count | Total (Sum), Count | <none> | PT1M | Yes |
Differential backup storage size Cumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. |
diff_backup_size_bytes |
Bytes | Average, Maximum, Minimum | <none> | P1D | Yes |
DTU percentage DTU Percentage. Applies to DTU-based databases. |
dtu_consumption_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
DTU Limit DTU Limit. Applies to DTU-based databases. |
dtu_limit |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
DTU used DTU used. Applies to DTU-based databases. |
dtu_used |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
DWU percentage DWU percentage. Applies only to data warehouses. |
dwu_consumption_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
DWU limit DWU limit. Applies only to data warehouses. |
dwu_limit |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
DWU used DWU used. Applies only to data warehouses. |
dwu_used |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Free amount consumed Free amount of vCore seconds consumed this month. Applies only to free database offer. |
free_amount_consumed |
Count | Average, Maximum, Minimum | <none> | PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
Free amount remaining Free amount of vCore seconds remaining this month. Applies only to free database offer. |
free_amount_remaining |
Count | Average, Maximum, Minimum | <none> | PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
Full backup storage size Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. |
full_backup_size_bytes |
Bytes | Average, Maximum, Minimum | <none> | P1D | Yes |
Failed Ledger Digest Uploads Ledger digests that failed to be uploaded. |
ledger_digest_upload_failed |
Count | Count | <none> | PT1M | Yes |
Successful Ledger Digest Uploads Ledger digests that were successfully uploaded. |
ledger_digest_upload_success |
Count | Count | <none> | PT1M | Yes |
Local tempdb percentage Local tempdb percentage. Applies only to data warehouses. |
local_tempdb_usage_percent |
Percent | Average, Maximum, Minimum | <none> | PT5M, PT15M, PT30M, PT1H, PT6H, PT12H, P1D | Yes |
Log backup storage size Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases. |
log_backup_size_bytes |
Bytes | Average, Maximum, Minimum | <none> | P1D | Yes |
Log IO percentage Log IO percentage. Not applicable to data warehouses. |
log_write_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Memory percentage Memory percentage. Applies only to data warehouses. |
memory_usage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data IO percentage Data IO percentage |
physical_data_read_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Queued queries Queued queries across all workload groups. Applies only to data warehouses. |
queued_queries |
Count | Total (Sum) | <none> | PT1M | Yes |
Sessions count Number of active sessions. Not applicable to Synapse DW Analytics. |
sessions_count |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Sessions percentage Sessions percentage. Not applicable to data warehouses. |
sessions_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data backup storage size Cumulative data backup storage size. Applies to Hyperscale databases. |
snapshot_backup_size_bytes |
Bytes | Average, Maximum, Minimum | <none> | P1D | Yes |
Data space used Data space used. Not applicable to data warehouses. |
storage |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data space used percent Data space used percent. Not applicable to data warehouses or hyperscale databases. |
storage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Workers percentage Workers percentage. Not applicable to data warehouses. |
workers_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
In-Memory OLTP storage percent In-Memory OLTP storage percent. Not applicable to data warehouses. |
xtp_storage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Category: InstanceAndAppAdvanced
Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
---|---|---|---|---|---|---|
SQL instance CPU percent CPU usage by all user and system workloads. Not applicable to data warehouses. |
sql_instance_cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
SQL instance memory percent Memory usage by the database engine instance. Not applicable to data warehouses. |
sql_instance_memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
SQL Server process core percent CPU usage as a percentage of the SQL DB process. Not applicable to data warehouses. (This metric is equivalent to sql_instance_cpu_percent, and will be removed in the future.) |
sqlserver_process_core_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
SQL Server process memory percent Memory usage as a percentage of the SQL DB process. Not applicable to data warehouses. (This metric is equivalent to sql_instance_memory_percent, and will be removed in the future.) |
sqlserver_process_memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Tempdb Data File Size Kilobytes Space used in tempdb data files in kilobytes. Not applicable to data warehouses. |
tempdb_data_size |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Tempdb Log File Size Kilobytes Space used in tempdb transaction log file in kilobytes. Not applicable to data warehouses. |
tempdb_log_size |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Tempdb Percent Log Used Space used percentage in tempdb transaction log file. Not applicable to data warehouses. |
tempdb_log_used_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Category: WorkloadManagement
Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
---|---|---|---|---|---|---|
Workload group active queries Active queries within the workload group. Applies only to data warehouses. |
wlg_active_queries |
Count | Total (Sum) | WorkloadGroupName , IsUserDefined |
PT1M | Yes |
Workload group query timeouts Queries that have timed out for the workload group. Applies only to data warehouses. |
wlg_active_queries_timeouts |
Count | Total (Sum) | WorkloadGroupName , IsUserDefined |
PT1M | Yes |
Workload group allocation by system percent Allocated percentage of resources relative to the entire system per workload group. Applies only to data warehouses. |
wlg_allocation_relative_to_system_percent |
Percent | Average, Maximum, Minimum, Total (Sum) | WorkloadGroupName , IsUserDefined |
PT1M | Yes |
Workload group allocation by cap resource percent Allocated percentage of resources relative to the specified cap resources per workload group. Applies only to data warehouses. |
wlg_allocation_relative_to_wlg_effective_cap_percent |
Percent | Average, Maximum, Minimum | WorkloadGroupName , IsUserDefined |
PT1M | Yes |
Effective cap resource percent 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. |
wlg_effective_cap_resource_percent |
Percent | Average, Maximum, Minimum | WorkloadGroupName , IsUserDefined |
PT1M | Yes |
Effective min resource percent Minimum percentage of resources reserved and isolated for the workload group, taking into account the service level minimum. Applies only to data warehouses. |
wlg_effective_min_resource_percent |
Percent | Average, Maximum, Minimum, Total (Sum) | WorkloadGroupName , IsUserDefined |
PT1M | Yes |
Workload group queued queries Queued queries within the workload group. Applies only to data warehouses. |
wlg_queued_queries |
Count | Total (Sum) | WorkloadGroupName , IsUserDefined |
PT1M | Yes |
Supported metrics for Microsoft.Sql/servers/elasticpools
The following table lists the metrics available for the Microsoft.Sql/servers/elasticpools resource type.
- All columns might not be present in every table.
- Some columns might be beyond the viewing area of the page. Select Expand table to view all available columns.
Table headings
- Category - The metrics group or classification.
- Metric - The metric display name as it appears in the Azure portal.
- Name in REST API - The metric name as referred to in the REST API.
- Unit - Unit of measure.
- Aggregation - The default aggregation type. Valid values: Average (Avg), Minimum (Min), Maximum (Max), Total (Sum), Count.
- Dimensions - Dimensions available for the metric.
- Time Grains - Intervals at which the metric is sampled. For example,
PT1M
indicates that the metric is sampled every minute,PT30M
every 30 minutes,PT1H
every hour, and so on. - DS Export- Whether the metric is exportable to Azure Monitor Logs via diagnostic settings. For information on exporting metrics, see Create diagnostic settings in Azure Monitor.
Category: Basic
Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
---|---|---|---|---|---|---|
Data space allocated Data space allocated |
allocated_data_storage |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data space allocated percent Data space allocated percent. Not applicable to hyperscale |
allocated_data_storage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
App CPU billed App CPU billed. Applies to serverless elastic pools. |
app_cpu_billed |
Count | Total (Sum) | <none> | PT1M | Yes |
App CPU percentage App CPU percentage. Applies to serverless elastic pools. |
app_cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
App memory percentage App memory percentage. Applies to serverless elastic pools. |
app_memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
CPU limit CPU limit. Applies to vCore-based elastic pools. |
cpu_limit |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
CPU percentage CPU percentage |
cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
CPU used CPU used. Applies to vCore-based elastic pools. |
cpu_used |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
DTU percentage DTU Percentage. Applies to DTU-based elastic pools. |
dtu_consumption_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
eDTU limit eDTU limit. Applies to DTU-based elastic pools. |
eDTU_limit |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
eDTU used eDTU used. Applies to DTU-based elastic pools. |
eDTU_used |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Log IO percentage Log IO percentage |
log_write_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data IO percentage Data IO percentage |
physical_data_read_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Sessions Count Number of active sessions |
sessions_count |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Sessions percentage Sessions percentage |
sessions_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data max size Data max size. Not applicable to hyperscale |
storage_limit |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data space used percent Data space used percent. Not applicable to hyperscale |
storage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Data space used Data space used |
storage_used |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
Workers percentage Workers percentage |
workers_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
In-Memory OLTP storage percent In-Memory OLTP storage percent. Not applicable to hyperscale |
xtp_storage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Category: InstanceAndAppAdvanced
Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
---|---|---|---|---|---|---|
SQL instance CPU percent CPU usage by all user and system workloads. Applies to elastic pools. |
sql_instance_cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
SQL instance memory percent Memory usage by the database engine instance. Applies to elastic pools. |
sql_instance_memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
SQL Server process core percent CPU usage as a percentage of the SQL DB process. Applies to elastic pools. (This metric is equivalent to sql_instance_cpu_percent, and will be removed in the future.) |
sqlserver_process_core_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
SQL Server process memory percent Memory usage as a percentage of the SQL DB process. Applies to elastic pools. (This metric is equivalent to sql_instance_memory_percent, and will be removed in the future.) |
sqlserver_process_memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Tempdb Data File Size Kilobytes Space used in tempdb data files in kilobytes. |
tempdb_data_size |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Tempdb Log File Size Kilobytes Space used in tempdb transaction log file in kilobytes. |
tempdb_log_size |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
Tempdb Percent Log Used Space used percentage in tempdb transaction log file |
tempdb_log_used_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Supported metrics for Microsoft.Sql/servers/jobAgents
The following table lists the metrics available for the Microsoft.Sql/servers/jobAgents resource type.
- All columns might not be present in every table.
- Some columns might be beyond the viewing area of the page. Select Expand table to view all available columns.
Table headings
- Category - The metrics group or classification.
- Metric - The metric display name as it appears in the Azure portal.
- Name in REST API - The metric name as referred to in the REST API.
- Unit - Unit of measure.
- Aggregation - The default aggregation type. Valid values: Average (Avg), Minimum (Min), Maximum (Max), Total (Sum), Count.
- Dimensions - Dimensions available for the metric.
- Time Grains - Intervals at which the metric is sampled. For example,
PT1M
indicates that the metric is sampled every minute,PT30M
every 30 minutes,PT1H
every hour, and so on. - DS Export- Whether the metric is exportable to Azure Monitor Logs via diagnostic settings. For information on exporting metrics, see Create diagnostic settings in Azure Monitor.
Category: Basic
Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
---|---|---|---|---|---|---|
Elastic Jobs Executions Failed Number of job executions that failed while trying to execute on target |
elastic_jobs_failed |
Count | Total (Sum), Count | <none> | PT1M | Yes |
Elastic Jobs Executions Successful Number of job executions that were able to successfully execute on target |
elastic_jobs_successful |
Count | Total (Sum), Count | <none> | PT1M | Yes |
Elastic Jobs Executions Timed Out Number of job executions that expired before execution was able to finish on target. |
elastic_jobs_timeout |
Count | Total (Sum), Count | <none> | PT1M | Yes |
Metric dimensions
For information about what metric dimensions are, see Multi-dimensional metrics.
This service has the following dimensions associated with its metrics.
Metric | Dimension |
---|---|
Failed Connections : System Errors | Error ValidatedDriverNameAndVersion |
Failed Connections : User Errors | Error ValidatedDriverNameAndVersion |
Successful Connections | SslProtocol ValidatedDriverNameAndVersion |
Workload group active queries | WorkloadGroupName IsUserDefined |
Workload group query timeouts | WorkloadGroupName IsUserDefined |
Workload group allocation by system percent | WorkloadGroupName IsUserDefined |
Workload group allocation by cap resource percent | WorkloadGroupName IsUserDefined |
Effective cap resource percent | WorkloadGroupName IsUserDefined |
Effective min resource percent | WorkloadGroupName IsUserDefined |
Workload group queued queries | WorkloadGroupName IsUserDefined |
Resource logs
This section lists the types of resource logs you can collect for this service. The section pulls from the list of all resource logs category types supported in Azure Monitor.
Supported resource logs for Microsoft.Sql/servers/databases
Category | Category display name | Log table | Supports basic log plan | Supports ingestion-time transformation | Example queries | Costs to export |
---|---|---|---|---|---|---|
AutomaticTuning |
Automatic tuning | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Blocks |
Blocks | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
DatabaseWaitStatistics |
Database Wait Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Deadlocks |
Deadlocks | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
DevOpsOperationsAudit |
Devops operations Audit Logs | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
DmsWorkers |
Dms Workers | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Errors |
Errors | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
ExecRequests |
Exec Requests | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
QueryStoreRuntimeStatistics |
Query Store Runtime Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
QueryStoreWaitStatistics |
Query Store Wait Statistics | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
RequestSteps |
Request Steps | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
SQLInsights |
SQL Insights | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
SqlRequests |
Sql Requests | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
SQLSecurityAuditEvents |
SQL Security Audit Event | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Timeouts |
Timeouts | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Waits |
Waits | AzureDiagnostics Logs from multiple Azure resources. |
No | No | Queries | No |
Azure Monitor Logs tables
This section lists the Azure Monitor Logs tables relevant to this service, which are available for query by Log Analytics using Kusto queries. The tables contain resource log data and possibly more depending on what is collected and routed to them.
Table | Notes |
---|---|
AzureActivity | Entries from the Azure Activity log that provides insight into any subscription-level or management group level events that have occurred in Azure. |
AzureDiagnostics | Azure Diagnostics reveals diagnostic data of specific resources and features for numerous Azure products including SQL databases, SQL elastic pools, and SQL managed instances. For more information, see Diagnostics metrics. |
AzureMetrics | Metric data emitted by Azure services that measure their health and performance. Activity from Azure products including SQL databases, SQL elastic pools, and SQL managed instances. |
Activity log
The linked table lists the operations that can be recorded in the activity log for this service. These operations are a subset of all the possible resource provider operations in the activity log.
For more information on the schema of activity log entries, see Activity Log schema.
Related content
- See Monitor SQL Database for a description of monitoring Azure SQL Database.
- See Monitor Azure resources with Azure Monitor for details on monitoring Azure resources.
- Monitor Azure SQL workloads with database watcher (preview)
- Review the Azure Monitor metrics and alerts including Recommended alert rules.