Managing SQL Server Workloads with Resource Governor
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.
Describes Resource Governor and how it can help database administrators manage server workload and resources.
Describes the basic concepts of Resource Governor and its components.
Describes Resource Governor security and considerations for ensuring the secure use of Resource Governor.
Describes Resource Governor states and changes in state that affect the Resource Governor configuration and request processing.
Describes how Resource Governor monitors its components.
Provides common scenarios that a database administrator might encounter and describes how to configure Resource Governor in response to the scenarios.
Provides an overview of the DDL and views that you can use to configure, run, and obtain information about a Resource Governor session.
Provides how-to topics about how to use Resource Governor, either by using Transact-SQL or SQL Server Management Studio.
Resource Governor DDL Commands
The following are the Transact-SQL reference topics for the new Resource Governor DDL commands:
Resource Governor Views
The following sections contain new topics for Resource Governor catalog views and dynamic management views:
SQL Server Reference Topics
The following SQL Server reference topics have been updated to reflect changes that are required for Resource Governor: