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 - Metrics export using data collection rules and Create diagnostic settings in Azure Monitor.
For information on metric retention, see Azure Monitor Metrics overview.
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 |