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 | Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| SQL dedicated pool | 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 |
| SQL dedicated pool | 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 |
| SQL dedicated pool | 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 |
| SQL dedicated pool | Connections Count of Total logins to the SQL pool |
Connections |
Count | Total (Sum) | Result |
PT1M | Yes |
| SQL dedicated pool | 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 |
| SQL dedicated pool | CPU used percentage CPU utilization across all nodes in the SQL pool |
CPUPercent |
Percent | Maximum, Minimum, Average | <none> | PT1M | No |
| SQL dedicated pool | DWU limit Service level objective of the SQL pool |
DWULimit |
Count | Maximum, Minimum, Average | <none> | PT1M | No |
| SQL dedicated pool | 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 |
| SQL dedicated pool | 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 |
| SQL dedicated pool | 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 |
| SQL dedicated pool | Memory used percentage Memory utilization across all nodes in the SQL pool |
MemoryUsedPercent |
Percent | Maximum, Minimum, Average | <none> | PT1M | No |
| SQL dedicated pool | Queued queries Cumulative count of requests queued after the max concurrency limit was reached |
QueuedQueries |
Count | Total (Sum) | IsUserDefined |
PT1M | No |
| SQL dedicated pool - Workload management | 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 |
| SQL dedicated pool - Workload management | 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 |
| SQL dedicated pool - Workload management | 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 |
| SQL dedicated pool - Workload management | 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 |
| SQL dedicated pool - Workload management | 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 |
| SQL dedicated pool - Workload management | 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 |
| SQL dedicated pool - Workload management | Workload group queued queries Cumulative count of requests queued after the max concurrency limit was reached |
WLGQueuedQueries |
Count | Total (Sum) | IsUserDefined, WorkloadGroup |
PT1M | No |