group_id

int

Unique ID of the workload group. Is not nullable.

name

sysname

Name of the workload group. Is not nullable.

importance

sysname

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.

Note:

Importance only applies to workload groups in the same resource pool.

request_max_memory_grant_percent

int

Maximum 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_sec

int

Maximum 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_sec

int

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.

max_dop

int

Maximum degree of parallelism for the workload group. The default value, 0, uses global settings. Is not nullable.

Note:

This setting will override the query option maxdop.

group_max_requests

int

Maximum number of concurrent requests. The default value, 0, specifies no limit. Is not nullable.

pool_id

int

ID of the resource pool that this workload group uses.