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 ...
Get SQL Server 2008 Administration in Action 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.
