Resource Management with Resource Governor - Microsoft SQL Server 2012 Performance Tuning - page 434

4. To check whether Resource Governor objects have been created, run the following

script to query DMVs sys.dm_resource_governor_resource_pools and sys.
dm_resource_governor_workload_groups :
SELECT
pool_id
,name
FROM sys.dm_resource_governor_resource_pools
GO

SELECT
group_id
,name
,pool_id
FROM sys.dm_resource_governor_workload_groups
GO

5. The preceding query should give you output similar to that shown in the following

screenshot:

How it works...

After getting connected to SQL Server, we started by dropping the Resource Governor objects
that we created in the previous recipe. Because we were to recreate the same objects with
T-SQL commands, we dropped the following, previously created objects:

F Resource pool: rp_WebApp
F Workload group: rg_WebApp
F Resource pool: rp_ReportApp
F Workload group: rg_ReportApp

Observe that after dropping these objects, the command ALTER RESOURCE GOVERNOR
RECONFIGURE was executed.