Azure SQL Database (vCore) monitoring

  • How-to guide
  • 4-min read

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 (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

  1. Go to Technologies & Processes Classic.
  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.

NameDescriptionDimensionsUnitRecommended
CPU percentageCPU percentagePercentApplicable
Data IO percentageData IO percentagePercentApplicable
Log IO percentageLog IO percentage. Not applicable to data warehouses.PercentApplicable
Data space usedData space used. Not applicable to data warehouses.ByteApplicable
Successful connectionsSuccessful ConnectionsTLS versionCountApplicable
Failed connections - system errorsFailed ConnectionsErrorCountApplicable
Failed connections - user errorsFailed Connections : User ErrorsErrorCount
Blocked by firewallBlocked by FirewallCountApplicable
DeadlocksDeadlocks. Not applicable to data warehouses.CountApplicable
Data space used percentData space used percent. Not applicable to data warehouses or hyperscale databases.PercentApplicable
In - memory OLTP storage percentIn-Memory OLTP storage percent. Not applicable to data warehouses.PercentApplicable
Workers percentageWorkers percentage. Not applicable to data warehouses.PercentApplicable
Sessions percentageSessions percentage. Not applicable to data warehouses.PercentApplicable
Sessions countNumber of active sessions. Not applicable to Synapse DW Analytics.Count
CPU limitCPU limit. Applies to vCore-based databases.CountApplicable
CPU usedCPU used. Applies to vCore-based databases.CountApplicable
SQL server process core percentCPU 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 percentMemory 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 kBSpace used in tempdb data files in kilobytes. Not applicable to data warehouses.Count
Tempdb log file size kBSpace used in tempdb transaction log file in kilobytes. Not applicable to data warehouses.Count
Tempdb percent log usedSpace used percentage in tempdb transaction log file. Not applicable to data warehouses.Percent
App CPU billedApp CPU billed. Applies to serverless databases.Count
App CPU percentageApp CPU percentage. Applies to serverless databases.Percent
App memory percentageApp memory percentage. Applies to serverless databases.Percent
Data space allocatedAllocated data storage. Not applicable to data warehouses.Byte
Full backup storage sizeCumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases.Byte
Differential backup storage sizeCumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases.Byte
Log backup storage sizeCumulative log backup storage size. Applies to vCore-based and Hyperscale databases.Byte
Successful ledger digest uploadsLedger digests that were successfully uploaded.Count
Failed ledger digest uploadsLedger digests that failed to be uploaded.Count
Related tags
Infrastructure Observability