Managing SQL Server Workloads with Resource Governor

SQL Server 2008 Books Online (November 2009)

SQL Server 2008 provides Resource Governor, a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU and memory that incoming application requests can use.

Resource Governor is configurable in SQL Server Management Studio by using Transact-SQL statements or by using Object Explorer.

Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.

The following table describes the topics in this section.

In This Section

Topic	Description
Introducing Resource Governor	Describes Resource Governor and how it can help database administrators manage server workload and resources.
Resource Governor Concepts	Describes the basic concepts of Resource Governor and its components.
Resource Governor Security	Describes Resource Governor security and considerations for ensuring the secure use of Resource Governor.
Resource Governor States	Describes Resource Governor states and changes in state that affect the Resource Governor configuration and request processing.
Resource Governor Monitoring	Describes how Resource Governor monitors its components.
Resource Governor Workload Management Scenarios	Provides common scenarios that a database administrator might encounter and describes how to configure Resource Governor in response to the scenarios.
Resource Governor DDL and System Views	Provides an overview of the DDL and views that you can use to configure, run, and obtain information about a Resource Governor session.
Resource Governor How-to Topics	Provides how-to topics about how to use Resource Governor, either by using Transact-SQL or SQL Server Management Studio.

Reference

Resource Governor DDL Commands

The following are the Transact-SQL reference topics for the new Resource Governor DDL commands:

CREATE WORKLOAD GROUP (Transact-SQL)	ALTER RESOURCE POOL (Transact-SQL)
ALTER WORKLOAD GROUP (Transact-SQL)	DROP RESOURCE POOL (Transact-SQL)
DROP WORKLOAD GROUP (Transact-SQL)	ALTER RESOURCE GOVERNOR (Transact-SQL)
CREATE RESOURCE POOL (Transact-SQL)

Resource Governor Views

The following sections contain new topics for Resource Governor catalog views and dynamic management views:

Resource Governor Catalog Views (Transact-SQL)

Resource Governor Related Dynamic Management Views (Transact-SQL)

SQL Server Reference Topics

The following SQL Server reference topics have been updated to reflect changes that are required for Resource Governor:

sys.dm_exec_cached_plans (Transact-SQL)	sys.dm_exec_sessions (Transact-SQL)
sys.dm_exec_query_memory_grants (Transact-SQL)	sys.dm_os_memory_brokers (Transact-SQL)
sys.dm_exec_query_resource_semaphores (Transact-SQL)	sys.dm_os_wait_stats (Transact-SQL)
sys.dm_exec_requests (Transact-SQL)

SQL Server Event Class Reference Topics

The following SQL Server event class reference topics have added to support Resource Governor:

CPU Threshold Exceeded Event Class	PreConnect:Starting Event Class
PreConnect:Completed Event Class