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

Configuring Resource Governor with SQL Server Management Studio

Before we look at configuring Resource Governor, we will first set up a real-life scenario.

Let's suppose that AdventureWorks2012 is our production database and it has billions of records. The database supports multiple applications. One of the applications supported by the database is a web application, which is an OLTP database application that consumes AdventureWorks2012 database. The normal functioning of the web application is very important compared to any other applications consuming the database server resources.

Another application is the reporting application that is used to generate reports. To fulfil reporting requirements, this application runs queries with heavy calculations. ...

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