© Peter A. Carter 2019
Peter A. CarterPro SQL Server 2019 Administrationhttps://doi.org/10.1007/978-1-4842-5089-1_24

24. Resource Governor

Peter A. Carter
(1)
SOUTHAMPTON, UK
 
Resource Governor provides a method for throttling applications at the SQL Server layer by imposing limits on CPU, memory, and physical IO on different classifications of connection. This chapter discusses the concepts the Resource Governor uses before demonstrating how to implement it. We then look at how to monitor the effect that Resource Governor has on resource utilization.

Resource Governor Concepts

Resource Governor uses resource pools to define a subset of server resources, workload groups as logical containers for similar session requests, and a classifier function to ...

Get Pro SQL Server 2019 Administration: A Guide for the Modern DBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.