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.