The Resource Governor Classifier identifies when a session starts and assigns the session to a workload group.
Workload groups function as containers for session requests that share similar classification criteria.
Workload groups are assigned to resource pools.
There are two built-in workload group, the internal group and the default group, but we can create user-defined workload groups. These groups can be moved from the default resource group to user-created resource groups.
Requests are classified into the default group under the following circumstances:
- There are no criteria to classify a request.
- A request is classified into a nonexistent workload group.
- There is a classification failure.
Creating a Workload Group using the wizard
- Navigate to the Management\Resource Governor node in Object Explorer.
- Right-click the Workload Groups folder under the Resource Pool that will host the workload group you are going to create and then
- Select “New Workload Group”
- In the Workload Groups For Resource Pool grid, enter a name
- Configure the values
- Click OK.
Creating a Workload Group using T-SQL
You can create a workload group by using the CREATE WORKLOAD GROUP Transact-SQL statement and then running the ALTER RESOURCE GOVERNOR RECONFIGURE statement. For example, use the following to create a groupBeta workload group name associated with the poolAlpha pool:
CREATE WORKLOAD GROUP <workload group name> USING <resource pool name>; GO ALTER RESOURCE GOVERNOR RECONFIGURE; GO
Question: What is the difference between resource pools and workload groups?