Supported metrics for Microsoft.Synapse/workspaces/sqlPools
The following table lists the metrics available for the Microsoft.Synapse/workspaces/sqlPools resource type.
Table headings
Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
Dimensions - Dimensions available for the metric.
Time Grains - Intervals at which the metric is sampled. For example, PT1M indicates that the metric is sampled every minute, PT30M every 30 minutes, PT1H every hour, and so on.
DS Export- Whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.
For information on exporting metrics, see - Metrics export using data collection rules and Create diagnostic settings in Azure Monitor.
For information on metric retention, see Azure Monitor Metrics overview.
For a list of supported logs, see Supported log categories - Microsoft.Synapse/workspaces/sqlPools
Category: SQL dedicated pool
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Active queries The active queries. Using this metric unfiltered and unsplit displays all active queries running on the system |
ActiveQueries |
Count | Total (Sum) | IsUserDefined |
PT1M | No |
| 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 |
AdaptiveCacheHitPercent |
Percent | Maximum, Minimum, Average | <none> | PT1M | No |
| Adaptive cache used percentage 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 |
AdaptiveCacheUsedPercent |
Percent | Maximum, Minimum, Average | <none> | PT1M | No |
| Connections Count of Total logins to the SQL pool |
Connections |
Count | Total (Sum) | Result |
PT1M | Yes |
| Connections blocked by firewall Count of connections blocked by firewall rules. Revisit access control policies for your SQL pool and monitor these connections if the count is high |
ConnectionsBlockedByFirewall |
Count | Total (Sum) | <none> | PT1M | No |
| CPU used percentage CPU utilization across all nodes in the SQL pool |
CPUPercent |
Percent | Maximum, Minimum, Average | <none> | PT1M | No |
| DWU limit Service level objective of the SQL pool |
DWULimit |
Count | Maximum, Minimum, Average | <none> | PT1M | No |
| DWU used Represents a high-level representation of usage across the SQL pool. Measured by DWU limit * DWU percentage |
DWUUsed |
Count | Maximum, Minimum, Average | <none> | PT1M | No |
| DWU used percentage Represents a high-level representation of usage across the SQL pool. Measured by taking the maximum between CPU percentage and Data IO percentage |
DWUUsedPercent |
Percent | Maximum, Minimum, Average | <none> | PT1M | No |
| Local tempdb used percentage Local tempdb utilization across all compute nodes - values are emitted every five minute |
LocalTempDBUsedPercent |
Percent | Maximum, Minimum, Average | <none> | PT1M | No |
| Memory used percentage Memory utilization across all nodes in the SQL pool |
MemoryUsedPercent |
Percent | Maximum, Minimum, Average | <none> | PT1M | No |
| Queued queries Cumulative count of requests queued after the max concurrency limit was reached |
QueuedQueries |
Count | Total (Sum) | IsUserDefined |
PT1M | No |
Category: SQL dedicated pool - Workload management
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Workload group active queries The active queries within the workload group. Using this metric unfiltered and unsplit displays all active queries running on the system |
WLGActiveQueries |
Count | Total (Sum) | IsUserDefined, WorkloadGroup |
PT1M | No |
| Workload group query timeouts 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) |
WLGActiveQueriesTimeouts |
Count | Total (Sum) | IsUserDefined, WorkloadGroup |
PT1M | No |
| Workload group allocation by max resource percent 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 |
WLGAllocationByEffectiveCapResourcePercent |
Percent | Maximum, Minimum, Average | IsUserDefined, WorkloadGroup |
PT1M | No |
| Workload group allocation by system percent The percentage allocation of resources relative to the entire system |
WLGAllocationBySystemPercent |
Percent | Maximum, Minimum, Average, Total (Sum) | IsUserDefined, WorkloadGroup |
PT1M | No |
| Effective cap resource percent The 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 |
WLGEffectiveCapResourcePercent |
Percent | Maximum, Minimum, Average | IsUserDefined, WorkloadGroup |
PT1M | No |
| Effective min resource percent The 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 |
WLGEffectiveMinResourcePercent |
Percent | Minimum, Maximum, Average, Total (Sum) | IsUserDefined, WorkloadGroup |
PT1M | No |
| Workload group queued queries Cumulative count of requests queued after the max concurrency limit was reached |
WLGQueuedQueries |
Count | Total (Sum) | IsUserDefined, WorkloadGroup |
PT1M | No |