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.
External reference
Setup
To set up the Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select Synapse Workspace.
Event support
- Supported
- Configure Azure Events in OpsRamp Azure Integration Discovery Profile.
Supported metrics
Workspace metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| azure_synapse_workspaces_BuiltinSqlPoolDataProcessedBytes Amount of data processed by queries. | Data processed | Bytes | Total |
| azure_synapse_workspaces_BuiltinSqlPoolLoginAttempts Count of login attempts that succeeded or failed. | Login attempts | Count | Total |
| azure_synapse_workspaces_BuiltinSqlPoolRequestsEnded Count of Requests that succeeded, failed, or were cancelled. | Requests ended | Count | Total |
| azure_synapse_workspaces_IntegrationActivityRunsEnded Count of integration activities that succeeded, failed, or were cancelled. | Activity runs ended | Count | Total |
| azure_synapse_workspaces_IntegrationPipelineRunsEnded Count of integration pipeline runs that succeeded, failed, or were cancelled. | Pipeline runs ended | Count | Total |
| azure_synapse_workspaces_IntegrationTriggerRunsEnded Count of integration triggers that succeeded, failed, or were cancelled. | Trigger Runs ended | Count | Total |
| azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsEnded Count of Apache Spark pool applications ended. | Ended Apache Spark applications | Count | Total |
SQL pool metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| azure_synapse_workspaces_sqlpools_ActiveQueries Active queries. Using this metric unfiltered and unsplit displays all active queries running on the system. | Active queries | Count | Total |
| 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 percentage | Percent | Maximum |
| 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 percentage | Percent | Maximum |
| azure_synapse_workspaces_sqlpools_Connections Count of total logins to the SQL pool. | Connections | Count | Total |
| 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 firewall | Count | Total |
| azure_synapse_workspaces_sqlpools_CPUPercent CPU utilization across all nodes in the SQL pool. | CPU Percent | Percent | Maximum |
| azure_synapse_workspaces_sqlpools_DWULimit Service level objective of the SQL pool. | DWU limit | Count | Maximum |
| azure_synapse_workspaces_sqlpools_DWUUsed Represents a high-level representation of usage across the SQL pool. Measured by DWU limit * DWU percentage. | DWU used | Count | Maximum |
| 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 percentage | Percent | Maximum |
| azure_synapse_workspaces_sqlpools_LocalTempDBUsedPercent Local tempdb utilization across all compute nodes - values are emitted every five minute. | Local tempdb used percentage | Percent | Maximum |
| azure_synapse_workspaces_sqlpools_MemoryUsedPercent Memory utilization across all nodes in the SQL pool. | Memory used percentage | Percent | Maximum |
| azure_synapse_workspaces_sqlpools_QueuedQueries Cumulative count of requests queued after the max concurrency limit was reached. | Queued queries | Count | Total |
| 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 queries | Count | Total |
| azure_synapse_workspaces_sqlpools_WLGActiveQueriesTimeouts Queries for the workload group that have timed out. Query timeouts reported by this metric are only after the query has started executing (it does not include wait time due to locking or resource waits). | Workload group query timeouts | Count | Total |
| 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 percent | Percent | Maximum |
| azure_synapse_workspaces_sqlpools_WLGAllocationBySystemPercent Percentage allocation of resources relative to the entire system. | Workload group allocation by system percent | Percent | Maximum |
| 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 percent | Percent | Maximum |
| 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 percent | Percent | Maximum |
| azure_synapse_workspaces_sqlpools_WLGQueuedQueries Cumulative count of requests queued after the max concurrency limit was reached. | Workload group queued queries | Count | Total |
Spark pool metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| azure_synapse_workspaces_bigdatapools_BigDataPoolAllocatedCores Allocated vCores for an Apache Spark Pool. | vCores allocated | Count | Maximum |
| azure_synapse_workspaces_bigdatapools_BigDataPoolAllocatedMemory Allocated Memory for Apache Spark Pool (GB). | Memory allocated (GB) | Count | Maximum |
| azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsActive Total Active Apache Spark Pool Applications. | Active Apache Spark applications | Count | Maximum |
| azure_synapse_workspaces_bigdatapools_BigDataPoolApplicationsEnded Count of Apache Spark pool applications ended. | Ended Apache Spark applications | Count | Total |