Using Transact-SQL to Configure and Use Resource Governor

You can use Transact-SQL DDL statements and catalog views to configure and monitor Resource Governor tasks. Additionally, you can create custom workload and resource management scenarios by using the DDL statements, stored procedures, and dynamic management views that support Resource Governor. 

You can use SQL Server Management Studio to create and execute the code samples that are provided in the How-to topics and the Resource Governor DDL reference topics. For more information, see Using Object Explorer.

Also, you can create your own query in any editor and save it in a text file that has a .sql file name extension. You can execute the query from the Windows command prompt by using the sqlcmd utility. For more information, see Using the sqlcmd Utility.