Resource Governor is designed to address the following types of resource issues which are commonly found in a database environment:

• Run-away queries on the server. In this scenario a resource intensive query can take up most or all of the server resources.
  
• Unpredictable workload execution. In this scenario concurrent applications on the same server have workloads of different size and type. For example, two data warehouse applications or a mix of OLTP and data warehouse applications. These applications are not isolated from each other and the resulting resource contention causes unpredictable workload execution.
  
• Setting workload priority. In this scenario one workload is allowed to proceed faster than another or is guaranteed to complete if there is resource contention. Resource Governor enables you to assign a relative importance to workloads.
  

All of the preceding scenarios require the ability to differentiate workloads in some way. Resource Governor provides:

• The ability to classify incoming connections and route their workloads to a specific group.
  
• The ability to monitor resource usage for each workload in a group.
  
• The ability to pool resources and set pool-specific limits on CPU usage and memory allocation. This prevents or minimizes the probability of run-away queries.
  
• The ability to associate grouped workloads with a specific pool of resources.
  
• The ability to identify and set priorities for workloads.
  

This release of Resource Governor has the following constraints:

• Resource management is limited to the SQL Server Database Engine. Resource Governor can not be used for Analysis Services, Integration Services, and Reporting Services.
  
• There is no workload monitoring or workload management between SQL Server instances.
  
• Limit specification applies to CPU bandwidth and memory managed by SQL Server.
  
• OLTP workloads. Resource Governor can manage OLTP workloads but these types of queries, which are typically very short in duration, are not always on the CPU long enough to apply bandwidth controls. This may skew in the statistics returned for CPU usage %.
  

The Resource Governor documentation is located in different nodes in Books Online. These locations are as follows in the Table of Contents.

Database Engine

    - Operations

        - Monitoring Events

            - SQL Server Event Class Reference

                - Stored Procedures Event Category (Category 1 of n.)

                    - PreConnect:Starting Event Class (Topic 1 of n.)

        - Performance

            - Managing SQL Server Workload and Resources (Conceptual, How-to)

                - Introducing Resource Governor (Topic 1 of n.)

    - Technical Reference

        - Transact-SQL Reference

            - CREATE RESOURCE POOL (Transact-SQL) (Topic 1 of n)

        - System Views

            - Catalog Views

                - Resource Governor Catalog Views

                    - sys.resource_governor_configuration (Transact-SQL) (Topic 1 of n)

            - Dynamic Management Views and Functions

                - Resource Governor Related Dynamic Management Views

                    - sys.dm_resource_governor_configuration (Topic 1 of n)

        - SQL Server Management Objects (SMO) Class Library

            - Microsoft.SqlServer.Management.Smo

                - ResourceGovernor Class (Managed Reference)

Concepts

Help and Information