Supported metrics for Microsoft.Sql/servers/databases
The following table lists the metrics available for the Microsoft.Sql/servers/databases resource type.
Table headings
Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, 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.
For information on metric retention, see Azure Monitor Metrics overview.
For a list of supported logs, see Supported log categories - Microsoft.Sql/servers/databases
| Category | Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Basic | Active queries Active queries across all workload groups. Applies only to data warehouses. |
active_queries |
Count | Total (Sum) | <none> | PT1M | Yes |
| Basic | Data space allocated Allocated data storage. Not applicable to data warehouses. |
allocated_data_storage |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | App CPU billed App CPU billed. Applies to serverless databases. |
app_cpu_billed |
Count | Total (Sum) | <none> | PT1M | Yes |
| Basic | 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 |
| Basic | App CPU percentage App CPU percentage. Applies to serverless databases. |
app_cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | App memory percentage App memory percentage. Applies to serverless databases. |
app_memory_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | 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 |
| Basic | Data storage size Data storage size. Applies to Hyperscale databases. |
base_blob_size_bytes |
Bytes | Average, Maximum, Minimum | <none> | P1D | Yes |
| Basic | Blocked by Firewall Blocked by Firewall |
blocked_by_firewall |
Count | Total (Sum), Count | <none> | PT1M | Yes |
| Basic | Cache hit percentage Cache hit percentage. Applies only to data warehouses. |
cache_hit_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | Cache used percentage Cache used percentage. Applies only to data warehouses. |
cache_used_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | Failed Connections : System Errors Failed Connections |
connection_failed |
Count | Total (Sum), Count | Error, ValidatedDriverNameAndVersion |
PT1M | Yes |
| Basic | Failed Connections : User Errors Failed Connections : User Errors |
connection_failed_user_error |
Count | Total (Sum), Count | Error, ValidatedDriverNameAndVersion |
PT1M | Yes |
| Basic | Successful Connections Successful Connections |
connection_successful |
Count | Total (Sum), Count | SslProtocol, ValidatedDriverNameAndVersion |
PT1M | Yes |
| Basic | CPU limit CPU limit. Applies to vCore-based databases. |
cpu_limit |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | CPU percentage CPU percentage |
cpu_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | CPU used CPU used. Applies to vCore-based databases. |
cpu_used |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | Deadlocks Deadlocks. Not applicable to data warehouses. |
deadlock |
Count | Total (Sum), Count | <none> | PT1M | Yes |
| Basic | 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 |
| Basic | DTU percentage DTU Percentage. Applies to DTU-based databases. |
dtu_consumption_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | DTU Limit DTU Limit. Applies to DTU-based databases. |
dtu_limit |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | DTU used DTU used. Applies to DTU-based databases. |
dtu_used |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | DWU percentage DWU percentage. Applies only to data warehouses. |
dwu_consumption_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | DWU limit DWU limit. Applies only to data warehouses. |
dwu_limit |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | DWU used DWU used. Applies only to data warehouses. |
dwu_used |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | 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 |
| Basic | 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 |
| Basic | 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 |
| Basic | Failed Ledger Digest Uploads Ledger digests that failed to be uploaded. |
ledger_digest_upload_failed |
Count | Count | <none> | PT1M | Yes |
| Basic | Successful Ledger Digest Uploads Ledger digests that were successfully uploaded. |
ledger_digest_upload_success |
Count | Count | <none> | PT1M | Yes |
| Basic | 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 |
| Basic | 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 |
| Basic | Log IO percentage Log IO percentage. Not applicable to data warehouses. |
log_write_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | Memory percentage Memory percentage. Applies only to data warehouses. |
memory_usage_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | Data IO percentage Data IO percentage |
physical_data_read_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | Queued queries Queued queries across all workload groups. Applies only to data warehouses. |
queued_queries |
Count | Total (Sum) | <none> | PT1M | Yes |
| Basic | Sessions count Number of active sessions. Not applicable to Synapse DW Analytics. |
sessions_count |
Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | Sessions percentage Sessions percentage. Not applicable to data warehouses. |
sessions_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | Data backup storage size Cumulative data backup storage size. Applies to Hyperscale databases. |
snapshot_backup_size_bytes |
Bytes | Average, Maximum, Minimum | <none> | P1D | Yes |
| InstanceAndAppAdvanced | 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 |
| InstanceAndAppAdvanced | 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 |
| InstanceAndAppAdvanced | 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 |
| InstanceAndAppAdvanced | 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 |
| Basic | Data space used Data space used. Not applicable to data warehouses. |
storage |
Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | 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 |
| InstanceAndAppAdvanced | 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 |
| InstanceAndAppAdvanced | 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 |
| InstanceAndAppAdvanced | 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 |
| WorkloadManagement | 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 |
| WorkloadManagement | 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 |
| WorkloadManagement | 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 |
| WorkloadManagement | 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 |
| WorkloadManagement | 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 |
| WorkloadManagement | 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 |
| WorkloadManagement | 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 |
| Basic | Workers percentage Workers percentage. Not applicable to data warehouses. |
workers_percent |
Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Basic | 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 |