sys.resource_governor_workload_groups (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Managed Instance
Returns the stored workload group configuration. Each row represents a workload group. Each workload group uses one resource pool.
| Column name | Data type | Description |
|---|---|---|
group_id |
int | Unique ID of the workload group. Not nullable. |
name |
sysname | Name of the workload group. Not nullable. |
importance |
sysname | Is the relative importance of a request in this workload group. Importance is one of the following: Low, Medium, High. Medium is the default. Note: Importance is relative to other workload groups in the same resource pool. Not nullable. |
request_max_memory_grant_percent |
int | Maximum memory grant for a single request, as a percentage of the total query workspace memory for a resource pool. The default value is 25. Not nullable. Note: If this setting is excessively high, queries requiring memory grants might be blocked until other queries complete, and in some cases might get an out-of-memory error. |
request_max_cpu_time_sec |
int | Maximum CPU use limit, in seconds, for a single request. The default value, 0, specifies no limit. Not nullable. For more information, see REQUEST_MAX_CPU_TIME_SEC. |
request_memory_grant_timeout_sec |
int | Memory grant time-out, in seconds, for a single request. The default value, 0, uses an internal calculation based on query cost. Not nullable. |
max_dop |
int | Maximum degree of parallelism for a request executing in the workload group. The default value, 0, uses global settings in the server or database scope. Not nullable. Note: If set to a value other than 0, overrides the global settings and the MAXDOP query hint. |
group_max_requests |
int | Maximum number of concurrent requests executing in the workload group. The default value, 0, specifies no limit. Not nullable. |
pool_id |
int | ID of the resource pool that this workload group uses. |
external_pool_id |
int | Applies to: SQL Server 2016 (13.x) and later. ID of the external resource pool that this workload group uses. |
request_max_memory_grant_percent_numeric |
float | Applies to: SQL Server 2019 (15.x) and later. Maximum memory grant for a single request, as a percentage of the total query workspace memory for a resource pool. The default value is 25. Not nullable. Note: Matches request_max_memory_grant_percent, but includes fractions of a percent if specified when creating or modifying a workload group. |
Remarks
The catalog view displays the stored metadata. To see the currently effective configuration, use the corresponding dynamic management view, sys.dm_resource_governor_workload_groups (Transact-SQL).
The stored and effective configurations can be different if the resource governor configuration has been changed but the ALTER RESOURCE GOVERNOR RECONFIGURE statement has not been executed.
Permissions
Requires the VIEW ANY DEFINITION permission.