sys.workload_management_workload_groups (Transact-SQL)

Applies to: Azure Synapse Analytics

Returns details for workload groups.

Column Name	Data Type	Description	Range
group_id	int	Unique ID of the workload group. Is not nullable.
name	sysname	Name of the workload group. Must be unique to the instance. Is not nullable.
importance	nvarchar(128)	Is the relative importance of a request in this workload group and across workload groups for shared resources. Is not nullable.	low, below_normal, normal (default), above_normal, high
min_percentage_resource	tinyint	Guaranteed amount of resources for requests in the workload group. Resources are not shared with other workload groups. Is not nullable.
cap_percentage_resource	tinyint	Hard cap on the resource percentage allocation for requests in the workload group. Limits the maximum resources allocated to the specified level. The allowed range for value is from 1 through 100.
request_min_resource_grant_percent	decimal(5,2)	Specifies the minimum amount of resources allocated to a request. The allowed range for value is from 0.75 to 100.
request_max_resource_grant_percent	decimal(5,2)	Specifies the maximum amount of resources allocated to a request.
query_execution_timeout_sec	int	The amount of execution time, in seconds, allowed before the query is canceled. Queries cannot be canceled once they have reached the return phase of execution. query_execution_timeout_sec does not include time spent queued.
query_wait_timeout_sec	int	INTERNAL
create_time	datetime	Time the workload group was created. Is not nullable.
modify_time	datetime	Time the workload group was last modified. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission.

Next steps

For a list of all the catalog views for Azure Synapse Analytics and Parallel Data Warehouse, see Azure Synapse Analytics and Parallel Data Warehouse Catalog Views. To create a workload group, see CREATE WORKLOAD GROUP. For more information on workload classification, see Workload Isolation