Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns the stored workload group configuration in SQL Server. Each workload group can subscribe to one and only one resource pool.
Applies to: SQL Server (SQL Server 2008 through current version).
Unique ID of the workload group. Is not nullable.
Name of the workload group. Is not nullable.
Is the relative importance of a request in this workload group. Importance is one of the following, with MEDIUM being the default:
Is not nullable.
Maximum memory grant, as a percentage, for a single request. The default value is 25. Is not nullable.
Maximum CPU use limit, in seconds, for a single request. The default value, 0, specifies no limit. Is not nullable.
Memory grant time-out, in seconds, for a single request. The default value, 0, uses an internal calculation based on query cost. Is not nullable.
Maximum degree of parallelism for the workload group. The default value, 0, uses global settings. Is not nullable.
Maximum number of concurrent requests. The default value, 0, specifies no limit. Is not nullable.
ID of the resource pool that this workload group uses.
Percentage of MIN_MEMORY_PERCENT, which is the minimum amount of memory reserved for the resource pool that cannot be shared with other resource pools. This value provides a guaranteed minimum for a group.
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.