Supported metrics for Microsoft.Sql/servers/elasticpools

The following table lists the metrics available for the Microsoft.Sql/servers/elasticpools 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.

Category Metric Name in REST API Unit Aggregation Dimensions Time Grains DS Export
Basic Data space allocated

Data space allocated
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 (Sum) <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
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

Next steps