Documentation forDatabase Performance Analyzer

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 Information link next to the metric on the Resources tab. The Information link is not available for all metrics.

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.