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 - Metrics export using data collection rules and 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: 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 |