Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In the SQL Server Resource Governor, a workload group serves as a container for session requests that have similar classification criteria. A workload allows for aggregate monitoring of the sessions, and defines policies for the sessions. Each workload group is in a resource pool, which represents a subset of the physical resources of an instance of the Database Engine. When a session is started, the Resource Governor classifier assigns the session to a specific workload group, and the session must run using the policies assigned to the workload group and the resources defined for the resource pool.
Workload Group Concepts
A workload group serves as a container for session requests that are similar according to the classification criteria that are applied to each request. A workload group allows the aggregate monitoring of resource consumption and the application of a uniform policy to all the requests in the group. A group defines the policies for its members.
Note
User-defined workload groups can be moved from one resource pool to another.
Resource Governor predefines two workload groups: the internal group and the default group. A user cannot change anything classified as an internal group, but can monitor it. Requests are classified into the default group when the following conditions exist:
There are no criteria to classify a request.
There is an attempt to classify the request into a non-existent group.
There is a general classification failure.
Resource Governor also provides DDL statements for creating, changing, and dropping workload groups.
Workload Group Tasks
Task Description |
Topic |
|---|---|
Describes how to create a workload group. |
|
Describes how to change workload group settings. |
|
Describes how to delete a workload group. |
See Also
Concepts
Resource Governor Resource Pool
Resource Governor Classifier Function