Using SQL Server Management Studio to Configure and Use Resource Governor
You can use Object Explorer in SQL Server Management Studio to perform Resource Governor configuration tasks. For example, you can enable or disable Resource Governor and change the Resource Governor configuration.
In Object Explorer, Resource Governor uses the following folder structure under the Management node:
Resource Governor
----Resource Pools
--------System Resource Pools
------------default
----------------Workload Groups
--------------------default
------------internal
----------------Workload Groups
--------------------internal
--------<user-defined resource pool>
------------Workload Groups
----------------<user-defined workload group>
In This Section
How to: Enable or Disable Resource Governor (SQL Server Management Studio)
How to: Create a Resource Pool (SQL Server Management Studio)
How to: Create a Workload Group (SQL Server Management Studio)
How to: Configure Resource Governor Using a Template (SQL Server Management Studio)
How to: Change Resource Pool or Workload Group Settings (SQL Server Management Studio)
How to: Delete a Workload Group or Resource Pool (SQL Server Management Studio)
See Also