• Home
  • Deploy Dynatrace
  • Set up Dynatrace on cloud platforms
  • Microsoft Azure
  • Integrations
  • Azure cloud services
  • Azure SQL Data Warehouse (legacy)

Azure SQL Data Warehouse (legacy)

The Azure SQL Data Warehouse overview page gives you a comprehensive view of how many jobs and tasks were completed over a period of time. You can also track nodes in different states, such as running, idle, or offline.

Prerequisites

  • Dynatrace version 1.224+
  • Environment ActiveGate version 1.205+

Enable monitoring

To enable monitoring for Azure SQL Data Warehouse, 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
  1. In the Dynatrace menu, go to Settings > Cloud and virtualization and select Azure.
  2. On the Azure overview page, select Edit for the desired Azure instance.
  3. Go to Services and select Add service, choose the desired service name from the list, and select Add service.
  4. 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 > Cloud and virtualization > Azure and select Edit for the desired Azure instance.
  2. For Resources to be monitored, select Monitor resources selected by tags.
  3. Enter the Key and Value.
  4. Select Save to save your configuration.

Note: To import the Azure tags automatically into Dynatrace, enable 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
  1. In the Dynatrace menu, go to Settings > Cloud and virtualization and select Azure.
  2. On the Azure overview page, scroll down and select Edit for the desired Azure instance.
  3. Go to Services and select Manage services.
  4. To add a metric, select the service for which you want to add metrics.
  5. Select Add new metric.
  6. From the menu, select the metric you want.
  7. Select Add metric to add the metric to monitoring.
  8. To configure a metric, select Edit.
  9. 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

  1. In the Dynatrace menu, go to Technologies.
  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.

Available metrics

Note: This service monitors the data warehouse type of SQL Databases. You can find the already monitored resources on the Azure overview page in the Cloud services section. To monitor the SQL Databases user kind, check Azure SQL Servers and the Databases components sections on the Azure overview page.

NameDescriptionDimensionsUnitRecommended
Active queriesActive queries. Using this metric unfiltered and unsplit displays all active queries running on the system.Count✔️
Blocked by firewallThe number of logins to the data warehouse from the database application that the firewall blocks.Count✔️
CPU percentageThe percentage of CPU that all nodes utilize for the data warehouse.Percent✔️
Cache hit percentageThe sum of all columnstore segments hits in the local SSD cache.Percent
Cache used percentageThe sum of all bytes in the local SSD cache across all nodes.Percent
DWU limitThe Data Warehouse Unit, which is the service-level objective of the data warehouse.Count✔️
DWU percentageThe maximum value when compared between CPU percentage and Data IO percentage.Percent✔️
DWU usedDWU limit * DWU percentageCount✔️
Data IO percentageThe percentage of IO that all nodes utilize for the data warehouse.Percent✔️
Effective cap resource percentThe effective cap resource percent for the workload group. If there are other workload groups with the effective min resource percent higher than 0, the effective cap resource percent is lowered proportionally.Is user defined, workload groupPercent
Effective min resource percentThe effective minimum resource percentage setting allowed, considering the service level and the workload group settings.Is user defined, workload groupPercent
Failed connectionsThe number of failed connections to the data warehouse from the database application.Count✔️
Local tempdb percentageThe percentage of the local tempdb that all compute nodes utilize.Percent
Memory percentageThe percentage of memory of the SQL Server utilized across all nodes for the data warehouse.Percent✔️
Queued queriesCumulative count of requests queued after the maximum concurrency limit was reached.Count✔️
Successful connectionsThe number of successful connections to the data from the database application.Count✔️
Workload group active queriesThe active queries within the workload group. Using this metric unfiltered and unsplit displays all active queries running on the system.Is user defined, workload groupCount
Workload group allocation by cap resource percent
The percentage allocation of resources relative to the effective cap resource percent per workload group. This metric provides the effective utilization of the workload group.Is user defined, Workload group.Percent
Workload group allocation by system percentThe percentage allocation of resources relative to the entire system.Is user defined, workload groupPercent
Workload group query timeoutsQueries for the workload group that have timed out.Is user defined, workload groupCount
Workload group queued queriesCumulative count of requests queued after the maximum concurrency limit was reached.Is user defined, workload groupCount