Microsoft SQL Server 2012 Bible

Views and Limitations

Following are three catalog views for the Resource governor:

• sys.resource_governor_configuration
• sys.resource_governor_resource_pools
• sys.resource_governor_workload_groups

These views enable you to view how the Resource Governor, your resource pools, and your Workload groups are configured.

Three Dynamic Management Views support the Resource Governor, which enable you to monitor it:

• sys.dm_resource_governor_workload_groups
• sys.dm_resource_governor_configuration
• sys.dm_resource_governor_resource_pools

The Resource Governor also has some limitations:

• It is limited only to the Database Engine. But some services are not a part of the Database Engine such as Analysis, Integration, and Reporting services. For these, you still must rely on other solutions to manage the resource problem (such as installing separate SQL Server instances).
• You can manage only a single instance through the Resource Governor. An organization may have more than a single instance but must manage each separately.
• The Resource Governor currently has only two resources: CPU and memory.