Edit

Azure SQL Database monitoring data reference

  • Article

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 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 <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 <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 <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 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, 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, Count Error, ValidatedDriverNameAndVersion PT1M Yes
Basic Failed Connections : User Errors

Failed Connections : User Errors		 connection_failed_user_error Count Total, Count Error, ValidatedDriverNameAndVersion PT1M Yes
Basic Successful Connections

Successful Connections		 connection_successful Count Total, 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, 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 <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 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 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 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 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 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

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 Metric Name in REST API Unit Aggregation Dimensions Time Grains DS Export
Basic Data space allocated

Data space allocated. Not applicable to hyperscale		 allocated_data_storage Bytes Average, Maximum, Minimum <none> PT1M Yes
Basic Data space allocated percent

Data space allocated percent. Not applicable to hyperscale		 allocated_data_storage_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Basic App CPU billed

App CPU billed. Applies to serverless elastic pools.		 app_cpu_billed Count Total <none> PT1M Yes
Basic App CPU percentage

App CPU percentage. Applies to serverless elastic pools.		 app_cpu_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Basic App memory percentage

App memory percentage. Applies to serverless elastic pools.		 app_memory_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Basic CPU limit

CPU limit. Applies to vCore-based elastic pools.		 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 elastic pools.		 cpu_used Count Average, Maximum, Minimum <none> PT1M Yes
Basic DTU percentage

DTU Percentage. Applies to DTU-based elastic pools.		 dtu_consumption_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Basic eDTU limit

eDTU limit. Applies to DTU-based elastic pools.		 eDTU_limit Count Average, Maximum, Minimum <none> PT1M Yes
Basic eDTU used

eDTU used. Applies to DTU-based elastic pools.		 eDTU_used Count Average, Maximum, Minimum <none> PT1M Yes
Basic Log IO percentage

Log IO percentage		 log_write_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 Sessions Count

Number of active sessions		 sessions_count Count Average, Maximum, Minimum <none> PT1M Yes
Basic Sessions percentage

Sessions percentage		 sessions_percent Percent Average, Maximum, Minimum <none> PT1M Yes
InstanceAndAppAdvanced 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
InstanceAndAppAdvanced 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
InstanceAndAppAdvanced 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
InstanceAndAppAdvanced 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
Basic Data max size

Data max size. Not applicable to hyperscale		 storage_limit Bytes Average, Maximum, Minimum <none> PT1M Yes
Basic Data space used percent

Data space used percent. Not applicable to hyperscale		 storage_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Basic Data space used

Data space used. Not applicable to hyperscale		 storage_used Bytes Average, Maximum, Minimum <none> PT1M Yes
InstanceAndAppAdvanced Tempdb Data File Size Kilobytes

Space used in tempdb data files in kilobytes.		 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.		 tempdb_log_size Count Average, Maximum, Minimum <none> PT1M Yes
InstanceAndAppAdvanced Tempdb Percent Log Used

Space used percentage in tempdb transaction log file		 tempdb_log_used_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Basic Workers percentage

Workers percentage		 workers_percent Percent Average, Maximum, Minimum <none> PT1M Yes
Basic In-Memory OLTP storage percent

In-Memory OLTP storage percent. Not applicable to hyperscale		 xtp_storage_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 Metric Name in REST API Unit Aggregation Dimensions Time Grains DS Export
Basic Elastic Jobs Executions Failed

Number of job executions that failed while trying to execute on target		 elastic_jobs_failed Count Total, Count <none> PT1M Yes
Basic Elastic Jobs Executions Successful

Number of job executions that were able to successfully execute on target		 elastic_jobs_successful Count Total, Count <none> PT1M Yes
Basic Elastic Jobs Executions Timed Out

Number of job executions that expired before execution was able to finish on target.		 elastic_jobs_timeout Count Total, Count <none> PT1M Yes

Metric dimensions

For information about what metric dimensions are, see Multi-dimensional metrics.

This service doesn't have any metrics that contain dimensions.

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