Microsoft SQL Server 2014 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Workload Groups
Workload groups are the logical containers for similar connections, which are grouped together as similar according to the classification criteria applied to each connection. A workload group also provides the mechanism for aggregate monitoring of resource consumption.
Resource Governor has two predefined workload groups: the internal group and default group. The internal workload group is used solely by internal Database Engine processes. You cannot change the classification criteria for the internal group, and you also cannot classify any user requests for assignment to the internal group. You can, however, monitor the internal group.
Connection requests are automatically classified into the default group when the following ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access