Resource Governor Enhancements (Database Engine)

The enhancements to the Resource Governor enable you to more effectively govern performance in multi-tenancy environments like private cloud. The enhancements include support for 64 resource pools, greater CPU usage control, and resource pool affinity for partitioning of physical resources and predictable resource allocation.

For a description of the new Resource Governor features in SQL Server 2012, see Resource Governor in SQL Server 2012.

The following topics provide additional information.

• ALTER RESOURCE POOL (Transact-SQL)

• CREATE RESOURCE POOL (Transact-SQL)

• sys.dm_exec_query_resource_semaphores (Transact-SQL)

• sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)

• sys.dm_resource_governor_resource_pools (Transact-SQL)

• sys.dm_exec_query_memory_grants (Transact-SQL)

• sys.resource_governor_workload_groups (Transact-SQL)