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 T-SQL scripts.

Getting ready

We will use the same scenario of the web application and the reporting application that we covered in our previous recipe. In this recipe, we will create required the resource pools and workload groups using T-SQL script...