By using SQL Server Management Studio or Transact-SQL to execute DDL statements, stored procedures, and views, you can configure and monitor Resource Governor workload groups and resource pools.
-
Using SQL Server Management Studio to Configure and Use Resource Governor
-
How to carry out Resource Governor tasks by using Management Studio.
-
Using Transact-SQL to Configure and Use Resource Governor
-
How to carry out Resource Governor tasks by using Transact-SQL.
Other Resources
Managing SQL Server Workloads with Resource Governor
Help and Information
Getting SQL Server 2008 Assistance