SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Using the New Resource Governor

The Resource Governor is new to SQL Server 2008 and provides an internal mechanism for the control and management of resource consumption by connections and processes. In the past, you had to use the external Windows System Resource Manager (WSRM) to get any reasonable amount of control over resource management. Now, with the Resource Governor, most resource management tasks can be handled within SQL Server 2008 itself.

The Resource Governor is comprised of resource pools, workload groups, and classifications. Resource pools collect the physical resources of the server and allow them to be used for assignment to workload groups. Microsoft suggests that a resource pool can be thought of as a virtual SQL Server inside ...