Azure Synapse is an integrated analytics service that accelerates time to insight across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.

Setup

To set up the OpsRamp Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select Synapse Workspace.

Workspace metrics

OpsRamp MetricMetric Display NameUnitAggregation TypeDescription
azure_synapse_workspaces_BuiltinSqlPoolDataProcessedBytesData processedBytesTotalAmount of data processed by queries.
azure_synapse_workspaces_BuiltinSqlPoolLoginAttemptsLogin attemptsCountTotalCount of login attempts that succeeded or failed.
azure_synapse_workspaces_BuiltinSqlPoolRequestsEndedRequests endedCountTotalCount of Requests that succeeded, failed, or were cancelled.
azure_synapse_workspaces_IntegrationActivityRunsEndedActivity runs endedCountTotalCount of integration activities that succeeded, failed, or were cancelled.
azure_synapse_workspaces_IntegrationPipelineRunsEndedPipeline runs endedCountTotalCount of integration pipeline runs that succeeded, failed, or were cancelled.
azure_synapse_workspaces_IntegrationTriggerRunsEndedTrigger Runs endedCountTotalCount of integration triggers that succeeded, failed, or were cancelled.
azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsEndedEnded Apache Spark applicationsCountTotalCount of Apache Spark pool applications ended.

SQL pool metrics

OpsRamp MetricMetric Display NameUnitAggregation TypeDescription
azure_synapse_workspaces_sqlpools_ActiveQueriesActive queriesCountTotalThe active queries. Using this metric unfiltered and unsplit displays all active queries running on the system.
azure_synapse_workspaces_sqlpools_AdaptiveCacheHitPercentAdaptive cache hit percentagePercentMaximumAdaptive cache hit percentage. 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.
azure_synapse_workspaces_sqlpools_AdaptiveCacheUsedPercentAdaptive cache used percentagePercentMaximumMeasures 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.
azure_synapse_workspaces_sqlpools_ConnectionsConnectionsCountTotalCount of total logins to the SQL pool.
azure_synapse_workspaces_sqlpools_ConnectionsBlockedByFirewallConnections blocked by firewallCountTotalCount of connections blocked by firewall rules. Revisit access control policies for your SQL pool and monitor these connections if the count is high.
azure_synapse_workspaces_sqlpools_CPUPercentCPU PercentPercentMaximumCPU utilization across all nodes in the SQL pool.
azure_synapse_workspaces_sqlpools_DWULimitDWU limitCountMaximumService level objective of the SQL pool.
azure_synapse_workspaces_sqlpools_DWUUsedDWU usedCountMaximumRepresents a high-level representation of usage across the SQL pool. Measured by DWU limit * DWU percentage.
azure_synapse_workspaces_sqlpools_DWUUsedPercentDWU used percentagePercentMaximumRepresents a high-level representation of usage across the SQL pool. Measured by taking the maximum between CPU percentage and Data IO percentage.
azure_synapse_workspaces_sqlpools_LocalTempDBUsedPercentLocal tempdb used percentagePercentMaximumLocal tempdb utilization across all compute nodes - values are emitted every five minute.
azure_synapse_workspaces_sqlpools_MemoryUsedPercentMemory used percentagePercentMaximumMemory utilization across all nodes in the SQL pool.
azure_synapse_workspaces_sqlpools_QueuedQueriesQueued queriesCountTotalCumulative count of requests queued after the max concurrency limit was reached.
azure_synapse_workspaces_sqlpools_WLGActiveQueriesWorkload group active queriesCountTotalActive queries within the workload group. Using this metric unfiltered and unsplit displays all active queries running on the system.
azure_synapse_workspaces_sqlpools_WLGActiveQueriesTimeoutsWorkload group query timeoutsCountTotalQueries for the workload group that have timed out. Query timeouts reported by this metric are only once the query has started executing (it does not include wait time due to locking or resource waits).
azure_synapse_workspaces_sqlpools_WLGAllocationByEffectiveCapResourcePercentWorkload group allocation by max resource percentPercentMaximumDisplays 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.
azure_synapse_workspaces_sqlpools_WLGAllocationBySystemPercentWorkload group allocation by system percentPercentMaximumPercentage allocation of resources relative to the entire system.
azure_synapse_workspaces_sqlpools_WLGEffectiveCapResourcePercentEffective cap resource percentPercentMaximumEffective cap resource percent for the workload group. If there are other workload groups with min_percentage_resource > 0, the effective_cap_percentage_resource is lowered proportionally.
azure_synapse_workspaces_sqlpools_WLGEffectiveMinResourcePercentEffective min resource percentPercentMaximumEffective min resource percentage setting allowed considering the service level and the workload group settings. The effective min_percentage_resource can be adjusted higher on lower service levels.
azure_synapse_workspaces_sqlpools_WLGQueuedQueriesWorkload group queued queriesCountTotalCumulative count of requests queued after the max concurrency limit was reached.

Spark pool metrics

OpsRamp MetricMetric Display NameUnitAggregation TypeDescription
azure_synapse_workspaces_bigdatapools_BigDataPoolAllocatedCoresvCores allocatedCountMaximumAllocated vCores for an Apache Spark Pool.
azure_synapse_workspaces_bigdatapools_BigDataPoolAllocatedMemoryMemory allocated (GB)CountMaximumAllocated Memory for Apache Spark Pool (GB).
azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsActiveActive Apache Spark applicationsCountMaximumTotal Active Apache Spark Pool Applications.
azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsEndedEnded Apache Spark applicationsCountTotalCount of Apache Spark pool applications ended.

Event support

  • Supported
  • Configure Azure Events in OpsRamp Azure Integration Discovery Profile.

External reference