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

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.