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 | <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 |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for