O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

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 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 ...

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