• Home
  • Deploy Dynatrace
  • Set up Dynatrace on cloud platforms
  • Microsoft Azure
  • Integrations
  • Azure cloud services
  • Azure SQL Servers

Azure SQL Servers

Dynatrace ingests metrics from Azure Metrics API for Azure SQL (SQL Servers, SQL Databases, SQL Elastic Pools). 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

  • Environment ActiveGate
  • To disable monitoring of built-in services you need Environment ActiveGate version 1.245+ and Dynatrace version 1.247+

Enable monitoring

To enable monitoring for this service, you need to set up integration with Azure Monitor.

Add the service to monitoring

To view service metrics, the service needs to be monitored in your Dynatrace environment.

Built-in services specifics

This is a built-in service. It’s monitored out-of-the-box once a new Azure integration instance is created. For built-in services, all metrics are recommended (changing configuration is not possible).

If monitoring for a built-in service was disabled and you want to re-enable monitoring
  1. In the Dynatrace menu, go to Settings and select Cloud and virtualization > Azure.
  2. On the Azure overview page, select the Edit icon for the Azure instance.
  3. Under Services, select Manage services.
  4. Select Add service, choose the service from the list, and select Add service.
  5. 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

  1. In the Dynatrace menu, go to Settings and select Cloud and virtualization > Azure.
  2. On the Azure overview page, select the Edit icon for the Azure instance.
  3. Set Resources to be monitored to Monitor resources selected by tags.
  4. 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.
  5. Select Save to save your configuration.

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

View service metrics

You can view Azure service metrics in your Dynatrace environment on the Azure subscription page or on your own dashboard.

View metrics on the Azure account page

To access metrics on the Azure account page

  1. In the Dynatrace menu, go to Azure.
  2. Choose the Azure subscription.
  3. Select the service whose metrics you want to check. Metrics for the selected service are visible under the infographic in the service section.

View metrics on a dashboard

You can create your own dashboard for viewing Azure service metrics. For information on how to create dashboards, see Create and edit Dynatrace dashboards.

Example of Azure built-in metrics

Example of Azure built-in services

Available metrics

Note: This service monitors SQL Servers, SQL Databases (only containing the "user" kind) and SQL Elastic Pools. You can find the already monitored resources on the Azure overview page, in the Databases components section. To monitor resources of the hyperscale/datawarehouse types, check the SQL Database Hyperscale/SQL Data Warehouse and the Azure overview Cloud services section.

SQL Databases

Metric keyNameUnitAggregationsMonitoring consumption
builtin:cloud.azure.sqlDatabase.connections.blockedByFirewall

Blocked by firewall

CountautovalueDDUs
builtin:cloud.azure.sqlDatabase.connections.failed

Failed connections

CountautovalueDDUs
builtin:cloud.azure.sqlDatabase.connections.successful

Successful connections

CountautovalueDDUs
builtin:cloud.azure.sqlDatabase.dtu.limit.count

DTU limit

CountautoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.dtu.limit.used

DTU used

CountautoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.dtu.consumptionPerc

DTU percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.io.dataRead

Data I/O percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.io.logWrite

Log I/O percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.storage.percent

Database size percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.storage.totalBytes

Total database size

ByteautoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.storage.xtpPercent

In-Memory OLTP storage percent

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.cpuPercent

CPU percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.deadlocks

Deadlocks

CountautovalueDDUs
builtin:cloud.azure.sqlDatabase.sessions

Sessions percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlDatabase.workers

Workers percentage

Percent (%)autoavgmaxminDDUs

SQL Elastic Pools

Metric keyNameUnitAggregationsMonitoring consumption
builtin:cloud.azure.sqlElasticPool.dtu.storage.limitBytes

Storage limit

ByteautoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.dtu.storage.percent

Database size percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.dtu.storage.usedBytes

Storage used

ByteautoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.dtu.storage.xtpPercent

In-memory OLTP storage percent

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.dtu.consumption

DTU percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.edtu.limit

eDTU limit

CountautoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.edtu.used

eDTU used

CountautoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.io.dataRead

Data I/O percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.io.logWrite

Log I/O percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.cpuPercent

CPU percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.sessions

Sessions percentage

Percent (%)autoavgmaxminDDUs
builtin:cloud.azure.sqlElasticPool.workers

Workers percentage

Percent (%)autoavgmaxminDDUs