Configuring Resource Governor with T-SQL script

In the previous recipe, we learnt how to enable/configure Resource Governor and create workload groups and resource pools, using SQL Server Management Studio.

However, DBAs always love to work with scripts. The reason is that scripts are scalable and reusable. They can be executed on different servers to create identical objects. They can even be executed without opening SQL Server Management Studio, with a utility such as SQLCMD.

As a DBA, you must know how to work with Resource Governor using T-SQL commands. In this recipe, we will implement Resource Governor rules for the same scenario that we came across in our previous recipe. In this example, we will see how to achieve the same functionality ...

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.