SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.  Read more...

In this chapter excerpt from "Microsoft SQL Server 2008 Management and Administration", learn how Resource Governor can improve SQL Server performance.  Read more...

SQL Server 2005 resource allocation policies treat all workloads equally, and allocate shared resources as they are requested. It sometimes causes a disproportionate distribution of resources, which in turn results in uneven performance or unexpected slowdowns whereas the new Resource Governor of SQL Server 2008 allows organizations to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to the end users.  Read more...

This article describes how Database Administrators can manage SQL Server workload and critical system resource consumption using Resource Governor in SQL Server 2008  Read more...

This article is about Resource Governor. A new feature introduced in SQL Server 2008. Special focus is placed on the T-SQL implementation of the new feature.  Read more...

Read more...

Read more...

Read more...