O'Reilly logo

Pro SQL Server Administration by Peter A Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 23

image

Resource Governor

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 determine to which workload group a specific ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required