© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
P. A. CarterPro SQL Server 2022 Administrationhttps://doi.org/10.1007/978-1-4842-8864-1_25

25. Resource Governor

Peter A. Carter1  
(1)
SOUTHAMPTON, UK
 

Resource Governor provides a method for throttling applications at the SQL Server layer by imposing limits on CPU, memory, and physical I/O on different classifications of connection. This chapter discusses the concepts the Resource Governor uses before demonstrating how to implement them. 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 ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.