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 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 total number of DTUs (Database Transaction Units) being used.

A DTU represents a combination of CPU, memory, data I/O and transaction log I/O. Microsoft places limits on these resources based on what service tier a database is in. When a database exceeds its limit for any resource, Microsoft restricts throughput, which slows performance.

DTU Utilization The percentage of available 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.

If CPU is near the upper limit, use DPA to determine which queries are contributing to high CPU usage, and determine if the queries can be tuned.

Memory

Metric Description
Memory Usage Utilization

The percentage of memory being used.

It is not unusual for this metric to be high. Data being used by applications is stored in memory to improve performance.

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 percent of the storage available to the database that is currently used.
Database Size The size of the database 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.