Redigera

Dela via


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