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 Type
azure_synapse_workspaces_BuiltinSqlPoolDataProcessedBytes

Amount of data processed by queries.
Data processedBytesTotal
azure_synapse_workspaces_BuiltinSqlPoolLoginAttempts

Count of login attempts that succeeded or failed.
Login attemptsCountTotal
azure_synapse_workspaces_BuiltinSqlPoolRequestsEnded

Count of Requests that succeeded, failed, or were cancelled.
Requests endedCountTotal
azure_synapse_workspaces_IntegrationActivityRunsEnded

Count of integration activities that succeeded, failed, or were cancelled.
Activity runs endedCountTotal
azure_synapse_workspaces_IntegrationPipelineRunsEnded

Count of integration pipeline runs that succeeded, failed, or were cancelled.
Pipeline runs endedCountTotal
azure_synapse_workspaces_IntegrationTriggerRunsEnded

Count of integration triggers that succeeded, failed, or were cancelled.
Trigger Runs endedCountTotal
azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsEnded

Count of Apache Spark pool applications ended.
Ended Apache Spark applicationsCountTotal

SQL pool metrics

OpsRamp MetricMetric Display NameUnitAggregation Type
azure_synapse_workspaces_sqlpools_ActiveQueries

Active queries. Using this metric unfiltered and unsplit displays all active queries running on the system.
Active queriesCountTotal
azure_synapse_workspaces_sqlpools_AdaptiveCacheHitPercent

Adaptive 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.
Adaptive cache hit percentagePercentMaximum
azure_synapse_workspaces_sqlpools_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.
Adaptive cache used percentagePercentMaximum
azure_synapse_workspaces_sqlpools_Connections

Count of total logins to the SQL pool.
ConnectionsCountTotal
azure_synapse_workspaces_sqlpools_ConnectionsBlockedByFirewall

Count of connections blocked by firewall rules. Revisit access control policies for your SQL pool and monitor these connections if the count is high.
Connections blocked by firewallCountTotal
azure_synapse_workspaces_sqlpools_CPUPercent

CPU utilization across all nodes in the SQL pool.
CPU PercentPercentMaximum
azure_synapse_workspaces_sqlpools_DWULimit

Service level objective of the SQL pool.
DWU limitCountMaximum
azure_synapse_workspaces_sqlpools_DWUUsed

Represents a high-level representation of usage across the SQL pool. Measured by DWU limit * DWU percentage.
DWU usedCountMaximum
azure_synapse_workspaces_sqlpools_DWUUsedPercent

Represents a high-level representation of usage across the SQL pool. Measured by taking the maximum between CPU percentage and Data IO percentage.
DWU used percentagePercentMaximum
azure_synapse_workspaces_sqlpools_LocalTempDBUsedPercent

Local tempdb utilization across all compute nodes - values are emitted every five minute.
Local tempdb used percentagePercentMaximum
azure_synapse_workspaces_sqlpools_MemoryUsedPercent

Memory utilization across all nodes in the SQL pool.
Memory used percentagePercentMaximum
azure_synapse_workspaces_sqlpools_QueuedQueries

Cumulative count of requests queued after the max concurrency limit was reached.
Queued queriesCountTotal
azure_synapse_workspaces_sqlpools_WLGActiveQueries

Active queries within the workload group. Using this metric unfiltered and unsplit displays all active queries running on the system.
Workload group active queriesCountTotal
azure_synapse_workspaces_sqlpools_WLGActiveQueriesTimeouts

Queries 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).
Workload group query timeoutsCountTotal
azure_synapse_workspaces_sqlpools_WLGAllocationByEffectiveCapResourcePercent

Displays 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.
Workload group allocation by max resource percentPercentMaximum
azure_synapse_workspaces_sqlpools_WLGAllocationBySystemPercent

Percentage allocation of resources relative to the entire system.
Workload group allocation by system percentPercentMaximum
azure_synapse_workspaces_sqlpools_WLGEffectiveCapResourcePercent

Effective 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.
Effective cap resource percentPercentMaximum
azure_synapse_workspaces_sqlpools_WLGEffectiveMinResourcePercent

Effective 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.
Effective min resource percentPercentMaximum
azure_synapse_workspaces_sqlpools_WLGQueuedQueries

Cumulative count of requests queued after the max concurrency limit was reached.
Workload group queued queriesCountTotal

Spark pool metrics

OpsRamp MetricMetric Display NameUnitAggregation Type
azure_synapse_workspaces_bigdatapools_BigDataPoolAllocatedCores

Allocated vCores for an Apache Spark Pool.
vCores allocatedCountMaximum
azure_synapse_workspaces_bigdatapools_BigDataPoolAllocatedMemory

Allocated Memory for Apache Spark Pool (GB).
Memory allocated (GB)CountMaximum
azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsActive

Total Active Apache Spark Pool Applications.
Active Apache Spark applicationsCountMaximum
azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsEnded

Count of Apache Spark pool applications ended.
Ended Apache Spark applicationsCountTotal

Event support

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

External reference