Azure SQL Database (vCore) monitoring
Dynatrace ingests metrics from Azure Metrics API for Azure SQL Database (vCore). 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
- 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 | Recommended |
|---|---|---|---|---|
| CPU percentage | CPU percentage | Percent |  | |
| Data IO percentage | Data IO percentage | Percent | | |
| Log IO percentage | Log IO percentage. Not applicable to data warehouses. | 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 | ||
| CPU limit | CPU limit. Applies to vCore-based databases. | Count | | |
| CPU used | CPU used. Applies to vCore-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 | ||
| App CPU billed | App CPU billed. Applies to serverless databases. | Count | ||
| App CPU percentage | App CPU percentage. Applies to serverless databases. | Percent | ||
| App memory percentage | App memory percentage. Applies to serverless databases. | Percent | ||
| Data space allocated | Allocated data storage. Not applicable to data warehouses. | Byte | ||
| Full backup storage size | Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. | Byte | ||
| Differential backup storage size | Cumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. | Byte | ||
| Log backup storage size | Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases. | Byte | ||
| Successful ledger digest uploads | Ledger digests that were successfully uploaded. | Count | ||
| Failed ledger digest uploads | Ledger digests that failed to be uploaded. | Count |