| title | Resource Governor Workload Group | |||
|---|---|---|---|---|
| description | Resource governor uses a workload group as a container for requests that are subject to common policies. | |||
| author | WilliamDAssafMSFT | |||
| ms.author | wiassaf | |||
| ms.reviewer | dfurman | |||
| ms.date | 01/02/2025 | |||
| ms.service | sql | |||
| ms.subservice | performance | |||
| ms.topic | concept-article | |||
| helpviewer_keywords |
|
|||
| monikerRange | >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current |
[!INCLUDE SQL Server SQL MI]
A resource governor workload group is a container for requests that are subject to common policies. A workload group supports aggregate monitoring of the sessions and requests, and defines request policies. Each workload group is in a resource pool, which represents a subset of the physical resources of a [!INCLUDEssDE] instance.
When a session is started, it is classified into a specific workload group. Workload group policies govern the requests executing on a session. Requests use the resources from the underlying resource pool.
A workload group serves as a container for sessions that are similar according to the classification criteria applied to each session. A workload group allows the aggregate monitoring of resource consumption and the use of common policies to all requests in the group. For example, you can limit the degree of parallelism or the maximum size of a memory grant for each query executing in a workload group.
Resource governor has two built-in workload groups: the internal group and the default group. You can't change the classification policies of the internal group, but you can monitor it.
Sessions are classified into the default group if:
- A classifier function doesn't exist.
- There is an attempt to classify the session into a nonexistent group.
- There is a general classification failure.
Resource pools can govern a variety of system resources. For more information, see CREATE WORKLOAD GROUP.
For more samples and a complete walkthrough, see Tutorial: Resource governor configuration examples and best practices.
| Task description | Article |
|---|---|
| Create a workload group | Create a workload group |
| Change workload group settings | Change workload group settings |
| Delete a workload group | Delete a workload group |
| Move a workload group | Move a workload group |
Resource governor provides DDL statements for creating, modifying, and deleting workload groups.
For more information, including the policies that can be specified for a workload group, see: