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 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	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	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	<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	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	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	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	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	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	IsUserDefined, WorkloadGroup	PT1M	No