Workload Groups

             Workload groups are logical entities that represent one or more client workloads. Workload groups act as a container which accepts sessions from SQL Server users based on classification criteria applied to each requests. 

                As in resource pools there are also two predefined workload groups named Internal and Default. Internal workload group cannot be changed but can monitor it to see how SQL Server is utilizing memory and CPU.

Incoming requests to the server are classified in to Default workload group when there is no classification criteria applied for it or there was an attempt made to classify the request in to nonexistent workload group or there is failure in classification. This default workload group is user configurable.

• CREATE WORKLOAD GROUP group_name
  USING pool_name
  GO
   

Option	Description	Default
IMPORTANCE	Importance between workload groups using the same resource pool.	MEDIUM
REQUEST_MAX_MEMORY_GRANT_PERCENT	Max memory grant from the resource pool for query execution.	25%
REQUEST_MEMORY_GRANT_TIMEOUT_SEC	How long to wait for a query execution memory grant.	0
REQUEST_MAX_CPU_TIME_SEC	Max amount of CPU  time a request can use	0
MAX_DOP	Max degree of parallelism.	0
GROUP_MAX_REQUESTS	Maximum concurrent requests per group.	0