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