Azure SQL Database (DTU) monitoring

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 enable monitoring for this service, you first need to set up integration with Azure Monitor.

Add the service to monitoring

In order to view the service metrics, you must add the service to monitoring in your Dynatrace environment.

To add a service to monitoring

In the Dynatrace menu, go to Settings > Cloud and virtualization and select Azure.
On the Azure overview page, select Edit for the desired Azure instance.
Go to Services and select Add service, choose the desired service name from the list, and select Add service.
Select Save changes to save your configuration.

Monitor resources based on tags

You can choose to monitor resources based on existing Azure tags, as Dynatrace automatically imports them from service instances.
To monitor resources based on tags

In the Dynatrace menu, go to Settings and select Cloud and virtualization > Azure.
On the Azure overview page, select the Edit icon for the Azure instance.
Set Resources to be monitored to Monitor resources selected by tags.
Enter key/value pairs to identify resources to exclude from monitoring or include in monitoring. You can enter multiple key/value pairs: each time you enter a pair, another empty row is displayed for you to edit as needed.
Select Save to save your configuration.

To import the Azure tags automatically into Dynatrace, turn on Capture Azure tags automatically.

Configure service metrics

Once you add a service, Dynatrace starts automatically collecting a suite of metrics for this particular service. These are recommended metrics.

Recommended metrics:

Are enabled by default
Can't be disabled
Can have recommended dimensions (enabled by default, can't be disabled)
Can have optional dimensions (disabled by default, can be enabled).

Apart from the recommended metrics, most services have the possibility of enabling optional metrics.

Optional metrics:

Can be added and configured manually

To add and configure metrics

In the Dynatrace menu, go to Settings > Cloud and virtualization and select Azure.
On the Azure overview page, scroll down and select Edit for the desired Azure instance.
Go to Services and select Manage services.
To add a metric, select the service for which you want to add metrics.
Select Add new metric.
From the menu, select the metric you want.
Select Add metric to add the metric to monitoring.
To configure a metric, select Edit.
Select Apply to save your configuration.

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

In the Dynatrace menu, go to Technologies.
Filter by service name and select the relevant custom device group.
Once you select the custom device group, you're on the custom device group overview page.
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.

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
CPU percentage	CPU percentage		Percent
Data IO percentage	Data IO percentage		Percent
Log IO percentage	Log IO percentage. Not applicable to data warehouses.		Percent
DTU percentage	DTU Percentage. Applies to DTU-based databases.		Percent
Data space used	Data space used. Not applicable to data warehouses.		Byte
Successful connections	Successful Connections	TLS version	Count
Failed connections - system errors	Failed Connections	Error	Count
Failed connections - user errors	Failed Connections : User Errors	Error	Count
Blocked by firewall	Blocked by Firewall		Count
Deadlocks	Deadlocks. Not applicable to data warehouses.		Count
Data space used percent	Data space used percent. Not applicable to data warehouses or hyperscale databases.		Percent
In - memory OLTP storage percent	In-Memory OLTP storage percent. Not applicable to data warehouses.		Percent
Workers percentage	Workers percentage. Not applicable to data warehouses.		Percent
Sessions percentage	Sessions percentage. Not applicable to data warehouses.		Percent
Sessions count	Number of active sessions. Not applicable to Synapse DW Analytics.		Count
DTU limit	DTU Limit. Applies to DTU-based databases.		Count
DTU used	DTU used. Applies to DTU-based databases.		Count
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