Azure SQL Database (DTU) monitoring

For information about differences between classic services and other services, see Migrate from Azure classic (formerly "built-in") services to cloud services.

Dynatrace ingests metrics from Azure Metrics API for Azure SQL Database (DTU). You can view metrics for each service instance, split metrics into multiple dimensions, and create custom charts that you can pin to your dashboards.

Prerequisites

  • Dynatrace version 1.199+
  • Environment ActiveGate version 1.195+

Enable monitoring

To learn how to enable service monitoring, see Enable service monitoring.

View service metrics

You can view the service metrics in your Dynatrace environment either on the custom device overview page or on your Dashboards page.

View metrics on the custom device overview page

To access the custom device overview page

  1. Go to Technologies & Processes or Technologies & Processes Classic (latest Dynatrace).
  2. Filter by service name and select the relevant custom device group.
  3. Once you select the custom device group, you're on the custom device group overview page.
  4. The custom device group overview page lists all instances (custom devices) belonging to the group. Select an instance to view the custom device overview page.

View metrics on your dashboard

Once you add a service to monitoring, a preset dashboard for the respective service containing all recommended metrics is automatically created on your Dashboards page. You can look for specific dashboards by filtering by Preset and then by Name.

For existing monitored services, you might need to resave your credentials for the preset dashboard to appear on the Dashboards page. To resave your credentials, go to Settings > Cloud and virtualization > Azure, select the desired Azure instance, then select Save.

You can't make changes on a preset dashboard directly, but you can clone and edit it. To clone a dashboard, open the browse menu (…) and select Clone.
To remove a dashboard from the dashboards list, you can hide it. To hide a dashboard, open the browse menu (…) and select Hide.

Hiding a dashboard doesn't affect other users.

Clone hide azure

Available metrics

This service monitors a part of Azure SQL (Microsoft.Sql/servers/databases). While you have this service configured, you can't have Azure Sql Servers (built-in) service turned on.

Name
Description
Dimensions
Unit
Recommended
CPU percentage
CPU percentage
Percent
Applicable
Data IO percentage
Data IO percentage
Percent
Applicable
Log IO percentage
Log IO percentage. Not applicable to data warehouses.
Percent
Applicable
DTU percentage
DTU Percentage. Applies to DTU-based databases.
Percent
Applicable
Data space used
Data space used. Not applicable to data warehouses.
Byte
Applicable
Successful connections
Successful Connections
TLS version
Count
Applicable
Failed connections - system errors
Failed Connections
Error
Count
Applicable
Failed connections - user errors
Failed Connections : User Errors
Error
Count
Blocked by firewall
Blocked by Firewall
Count
Applicable
Deadlocks
Deadlocks. Not applicable to data warehouses.
Count
Applicable
Data space used percent
Data space used percent. Not applicable to data warehouses or hyperscale databases.
Percent
Applicable
In - memory OLTP storage percent
In-Memory OLTP storage percent. Not applicable to data warehouses.
Percent
Applicable
Workers percentage
Workers percentage. Not applicable to data warehouses.
Percent
Applicable
Sessions percentage
Sessions percentage. Not applicable to data warehouses.
Percent
Applicable
Sessions count
Number of active sessions. Not applicable to Synapse DW Analytics.
Count
DTU limit
DTU Limit. Applies to DTU-based databases.
Count
Applicable
DTU used
DTU used. Applies to DTU-based databases.
Count
Applicable
SQL server process core percent
CPU usage as a percentage of the SQL DB process. Not applicable to data warehouses. (This metric is equivalent to sql_instance_cpu_percent, and will be removed in the future.)
Percent
SQL server process memory percent
Memory usage as a percentage of the SQL DB process. Not applicable to data warehouses. (This metric is equivalent to sql_instance_memory_percent, and will be removed in the future.)
Percent
Tempdb data file size kB
Space used in tempdb data files in kilobytes. Not applicable to data warehouses.
Count
Tempdb log file size kB
Space used in tempdb transaction log file in kilobytes. Not applicable to data warehouses.
Count
Tempdb percent log used
Space used percentage in tempdb transaction log file. Not applicable to data warehouses.
Percent
Data space allocated
Allocated data storage. Not applicable to data warehouses.
Byte
Successful ledger digest uploads
Ledger digests that were successfully uploaded.
Count
Failed ledger digest uploads
Ledger digests that failed to be uploaded.
Count