Resource Governor Workload Group
Applies to: SQL Server Azure SQL Managed Instance
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.
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.
Opomba
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.
Task Description | Topic |
---|---|
Describes how to create a workload group. | Create a Workload Group |
Describes how to change workload group settings. | Change Workload Group Settings |
Describes how to delete a workload group. | Delete a Workload Group |
Resource Governor
Enable Resource Governor
Resource Governor Resource Pool
Resource Governor Classifier Function
Configure Resource Governor Using a Template
View Resource Governor Properties