Chapter 16. Resource Governor

Throughout this book, we've looked at a number of performance-management tools used for observation and/or simulation purposes. What's missing from those tools is a mechanism to control resource usage based on the connection source, now possible using Resource Governor, introduced in the Enterprise Edition of SQL Server 2008.

In this chapter, we'll begin with an overview of Resource Governor before concentrating on its major components: the classifier function, workload groups, and resource pools. We'll conclude the chapter with an example implementation using T-SQL script and cover some of the monitoring techniques used.