• Home
  • Deploy Dynatrace
  • Set up Dynatrace on cloud platforms
  • Microsoft Azure
  • Integrations
  • Azure cloud services
  • Azure Synapse Analytics (Synapse Workspace, Apache Spark pool, SQL pool) monitoring

Azure Synapse Analytics (Synapse Workspace, Apache Spark pool, SQL pool) monitoring

Dynatrace ingests metrics from Azure Metrics API for Azure Analytics (Synapse Workspace, Apache Spark pool, SQL pool). 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.203+
  • 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
  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.

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.

Note: 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.

Note: Hiding a dashboard doesn't affect other users.

Clone hide azure

Synapse workspace

Available metrics

Synapse Workspace

NameDescriptionDimensionsUnitRecommended
IntegrationActivityRunsEndedThe number of orchestration activities that succeeded, failed, or were cancelledResult, Failure type, Activity, Activity type, PipelineCount✔️
IntegrationPipelineRunsEndedThe number of orchestration pipeline runs that succeeded, failed, or were cancelledResult, Failure type, PipelineCount✔️
IntegrationTriggerRunsEndedThe number of orchestration triggers that succeeded, failed, or were cancelledResult, Failure type, TriggerCount✔️
BuiltinSqlPoolLoginAttemptsThe number of login attempts that succeeded or failedResult, Failure typeCount
BuiltinSqlPoolRequestsEndedThe number of queries that succeeded, failed, or were cancelledResult, Failure typeCount✔️
BuiltinSqlPoolDataProcessedBytesThe amount of data processed by queriesByte✔️

Apache Spark pool

NameDescriptionDimensionsUnitRecommended
BigDataPoolApplicationsActiveActive Apache Spark applicationsJob stateCount✔️
BigDataPoolApplicationsEndedEnded Apache Spark applicationsJob result, Job typeCount✔️
BigDataPoolAllocatedMemoryMemory allocated (in GB)Submitter IDCount✔️
BigDataPoolAllocatedCoresV cores allocatedSubmitter IDCount✔️

SQL pool

NameDescriptionUnitDimensionsRecommended
AdaptiveCacheHitPercentMeasures how well workloads are utilizing the adaptive cache. Use this metric with the cache hit percentage metric to determine whether to scale for additional capacity or rerun workloads to hydrate the cache.Percent✔️
AdaptiveCacheUsedPercentMeasures how well workloads are utilizing the adaptive cache. Use this metric with the cache used percentage metric to determine whether to scale for additional capacity or rerun workloads to hydrate the cache.Percent✔️
ConnectionsThe number of total logins to the SQL poolCountResult✔️
ConnectionsBlockedByFirewallThe number of connections blocked by firewall rulesCount
DWULimitThe service-level objective of the SQL poolCount✔️
DWUUsedThe usage across the SQL pool, measured by DWU limit * DWU percentage.Count✔️
DWUUsedPercentThe usage across the SQL pool, measured by taking the maximum between CPU percentage and Data IO percentagePercent✔️
LocalTempDBUsedPercentThe local tempdb utilization across all compute nodes. Values are emitted every five minutes.Percent✔️
MemoryUsedPercentThe memory utilization across all nodes in the SQL poolPercent✔️
WLGActiveQueriesThe active queries within the workload groupCountIs user defined, Workload group✔️
WLGActiveQueriesTimeoutsThe queries for the workload group that have timed outCountIs user defined, Workload group✔️
WLGAllocationByMaxResourcePercentThe percentage allocation of resources relative to the effective cap resource percent per workload groupPercentIs user defined, Workload group
WLGAllocationBySystemPercentThe percentage allocation of resources relative to the entire systemPercentIs user defined, Workload group
WLGEffectiveCapResourcePercentThe effective cap resource percent for the workload groupPercentIs user defined, Workload group
WLGQueuedQueriesThe cumulative number of requests queued after the max concurrency limit was reachedCountIs user defined, Workload group
wlg_effective_min_resource_percentThe effective minimum resource percentage setting allowed, considering the service level and the workload group settingsPercentIs user defined, Workload group