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

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.

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

View service metrics

Once you add the service to monitoring, you can view the service metrics in your Dynatrace environment either on your dashboard page or on the custom device overview page.

Import preset dashboards

Dynatrace provides preset Azure dashboards that you can import from GitHub to your environment's dashboard page. Once you download a preset dashboard locally, there are two ways to import it.

synapse-workspace

Available metrics

Synapse Workspace

Name Description Dimensions Unit Recommended
OrchestrationActivityRunsEnded The number of orchestration activities that succeeded, failed, or were cancelled Result, Failure type, Activity, Activity type, Pipeline Count ✔️
OrchestrationPipelineRunsEnded The number of orchestration pipeline runs that succeeded, failed, or were cancelled Result, Failure type, Pipeline Count ✔️
OrchestrationTriggersEnded The number of orchestration triggers that succeeded, failed, or were cancelled Result, Failure type, Trigger Count ✔️
SQLOnDemandLoginAttempts The number of login attempts that succeeded or failed Result, Failure type Count
SQLOnDemandQueriesEnded The number of queries that succeeded, failed, or were cancelled Result, Failure type Count ✔️
SQLOnDemandQueryProcessedBytes The amount of data processed by queries Byte ✔️

Apache Spark pool

Name Description Dimensions Unit Recommended
CoresCapacity Cores capacity Count ✔️
MemoryCapacityGB Memory capacity (in GB) Count ✔️
SparkJobsEnded The number of ended applications Job type, Job result Count ✔️

SQL pool

Name Description Unit Dimensions Recommended
AdaptiveCacheHitPercent Measures 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 ✔️
AdaptiveCacheUsedPercent Measures 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 ✔️
Connections The number of total logins to the SQL pool Count Result ✔️
ConnectionsBlockedByFirewall The number of connections blocked by firewall rules Count
DWULimit The service-level objective of the SQL pool Count ✔️
DWUUsed The usage across the SQL pool, measured by DWU limit * DWU percentage. Count ✔️
DWUUsedPercent The usage across the SQL pool, measured by taking the maximum between CPU percentage and Data IO percentage Percent ✔️
LocalTempDBUsedPercent The local tempdb utilization across all compute nodes. Values are emitted every five minutes. Percent ✔️
MemoryUsedPercent The memory utilization across all nodes in the SQL pool Percent ✔️
WLGActiveQueries The active queries within the workload group Count Is user defined, Workload group ✔️
WLGActiveQueriesTimeouts The queries for the workload group that have timed out Count Is user defined, Workload group ✔️
WLGAllocationByMaxResourcePercent The percentage allocation of resources relative to the effective cap resource percent per workload group Percent Is user defined, Workload group
WLGAllocationBySystemPercent The percentage allocation of resources relative to the entire system Percent Is user defined, Workload group
WLGEffectiveCapResourcePercent The effective cap resource percent for the workload group Percent Is user defined, Workload group
WLGQueuedQueries The cumulative number of requests queued after the max concurrency limit was reached Count Is user defined, Workload group
wlg_effective_min_resource_percent The effective minimum resource percentage setting allowed, considering the service level and the workload group settings Percent Is user defined, Workload group