Chapter 19. Resource Management with Resource Governor
In this chapter we will cover:
- Configuring Resource Governor with SQL Server Management Studio
- Configuring Resource Governor with T-SQL script
- Monitoring Resource Governor
Introduction
In previous chapters, you saw how you can improve the database server's performance in different ways. You have learnt how to improve the performance of queries by implementing proper indexes and keeping statistics updated, using query hints and plan guides, implementing optimum physical database design, and changing server configuration settings.
It is natural that you try your best to get the maximum out of your database server by tuning your databases in different ways as just described, even though you may be ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook 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.
