Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
- Advanced platform metrics - A premium, paid tier of platform metrics in Azure Monitor that provide more granular observability for Azure resources.
- 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,
PT1Mindicates that the metric is sampled every minute,PT30Mevery 30 minutes,PT1Hevery hour, and so on. - DS Export -S 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 | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Data space allocated Data space allocated |
allocated_data_storage |
No | Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Data space allocated percent Data space allocated percent. Not applicable to hyperscale |
allocated_data_storage_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| App CPU billed App CPU billed. Applies to serverless elastic pools. |
app_cpu_billed |
No | Count | Total (Sum) | <none> | PT1M | Yes |
| App CPU percentage App CPU percentage. Applies to serverless elastic pools. |
app_cpu_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| App memory percentage App memory percentage. Applies to serverless elastic pools. |
app_memory_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| CPU limit CPU limit. Applies to vCore-based elastic pools. |
cpu_limit |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| CPU percentage CPU percentage |
cpu_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| CPU used CPU used. Applies to vCore-based elastic pools. |
cpu_used |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| DTU percentage DTU Percentage. Applies to DTU-based elastic pools. |
dtu_consumption_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| eDTU limit eDTU limit. Applies to DTU-based elastic pools. |
eDTU_limit |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| eDTU used eDTU used. Applies to DTU-based elastic pools. |
eDTU_used |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Log IO percentage Log IO percentage |
log_write_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Data IO percentage Data IO percentage |
physical_data_read_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Sessions Count Number of active sessions |
sessions_count |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Sessions percentage Sessions percentage |
sessions_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Data max size Data max size. Not applicable to hyperscale |
storage_limit |
No | Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Data space used percent Data space used percent. Not applicable to hyperscale |
storage_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Data space used Data space used |
storage_used |
No | Bytes | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Workers percentage Workers percentage |
workers_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| In-Memory OLTP storage percent In-Memory OLTP storage percent. Not applicable to hyperscale |
xtp_storage_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
Category: InstanceAndAppAdvanced
| Metric | Name in REST API | Advanced platform metrics | 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 |
No | 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 |
No | 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 |
No | 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 |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Tempdb Data File Size Kilobytes Space used in tempdb data files in kilobytes. |
tempdb_data_size |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Tempdb Log File Size Kilobytes Space used in tempdb transaction log file in kilobytes. |
tempdb_log_size |
No | Count | Average, Maximum, Minimum | <none> | PT1M | Yes |
| Tempdb Percent Log Used Space used percentage in tempdb transaction log file |
tempdb_log_used_percent |
No | Percent | Average, Maximum, Minimum | <none> | PT1M | Yes |