Azure SQL database metrics collected by DPA
The following sections list the metrics that DPA collects for Azure SQL database instances.
- Learn how to view these metrics and change the thresholds.
- For detailed information about resolving issues, click the
next to the metric on the Resources tab. The Information link is not available for all metrics.
- If the database instance runs on a virtual machine (VM), metrics collected for the VM are described in VM metrics collected by DPA
DTU
Metric |
Description |
DTU Consumption |
The number of DTUs being used. |
DTU Utilization |
The percentage of the maximum DTUs being used. Use this value to determine the appropriate service tier for your needs. |
DTU Limit |
The DTU limit for this database instance. |
CPU
Metric |
Description |
CPU Utilization |
The percentage of CPU being used based on the DTU limit. |
Memory
Metric |
Description |
Memory Usage Utilization |
The percentage of memory being used. |
XTP Storage Utilization |
The percentage of XTP storage utilization based on the DTU limit. This resource is available only for databases running on the Premium service tier. Zero percent is returned for the Basic and Standard service tiers. |
Disk
Metric |
Description |
Data I/O Utilization |
The percentage of data I/O utilization based on the DTU limit. |
Log Write Utilization |
The percentage of log write Utilization based on the DTU limit |
Database Storage Consumption |
The percentage of the allotted storage space used by the database instance. |
Database Size |
The size of the data file in GB (rounded up to the nearest GB). |
Network
Metric |
Description |
Round-trip Time |
The round-trip time when running "select 1" against this database (includes network time but not connect time). If this is high, contact your network administrator to understand network latency.
|
Sessions
Metric |
Description |
Active Sessions |
The number of sessions in this database actively performing work or waiting for a resource (excludes idle sessions). |
Blocked Sessions |
The number of sessions in this database that are blocked because another session is using a needed resource. |
Max Worker Utilization |
The percentage of Max Worker Utilization based on the database limit. |
Max Session Utilization |
The percentage of Max Session Utilization based on the database limit. |
Waits
Metric |
Description |
Total Instance Wait Time |
Total wait time for the database instance. |
License Compliance
Metric |
Description |
Connected Users |
The number of distinct users (that is, login names) connected to this database (even if the connection is idle). |
Connected Machines |
The number of distinct client machines connected to this database (even if the connection is idle). This value is typically used for per-device licensing. It can also be used to approximate per-user licensing. |
Sessions |
The number of sessions connected to this database (even if the connection is idle). This value is typically used for licensing based on number of concurrent connections. |