sys.resource_governor_workload_groups (Transact-SQL)

 

Updated: March 16, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the stored workload group configuration in SQL Server. Each workload group can subscribe to one and only one resource pool.

Column nameData typeDescription
group_idintUnique ID of the workload group. Is not nullable.
namesysnameName of the workload group. Is not nullable.
importancesysnameNote: Importance only applies to workload groups in the same resource pool.

Is the relative importance of a request in this workload group. Importance is one of the following, with MEDIUM being the default: LOW, MEDIUM, HIGH.

Is not nullable.
request_max_memory_grant_percentintMaximum memory grant, as a percentage, for a single request. The default value is 25. Is not nullable.

 Note: If this setting is higher than 50 percent, large queries will run one at a time. Therefore, there is greater risk of getting an out-of-memory error while the query is running.
request_max_cpu_time_secintMaximum CPU use limit, in seconds, for a single request. The default value, 0, specifies no limit. Is not nullable.

 Note: For more information, see CPU Threshold Exceeded Event Class.
request_memory_grant_timeout_secintMemory grant time-out, in seconds, for a single request. The default value, 0, uses an internal calculation based on query cost. Is not nullable.
max_dopintMaximum degree of parallelism for the workload group. The default value, 0, uses global settings. Is not nullable.

 Node: This setting will override the query option maxdop.
group_max_requestsintMaximum number of concurrent requests. The default value, 0, specifies no limit. Is not nullable.
pool_idintID of the resource pool that this workload group uses.
external_pool_idintApplies to: SQL Server 2016 through SQL Server 2016.

ID of the external resource pool that this workload group uses.

The catalog view displays the stored metadata. To see the in-memory configuration, use the corresponding dynamic management view, sys.dm_resource_governor_workload_groups (Transact-SQL).

The stored and in-memory configuration can be different if the Resource Governor configuration has been changed but the ALTER RESOURCE GOVERNOR RECONFIGURE statement has not been applied.

Requires VIEW ANY DEFINITION permission to view contents, requires CONTROL SERVER permission to change contents.

sys.dm_resource_governor_workload_groups (Transact-SQL)
Catalog Views (Transact-SQL)
Resource Governor Catalog Views (Transact-SQL)

Community Additions

ADD
Show: