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

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