Using the Resource Governor
SQL Server Technical Article
Writer: Aaron Bertrand, Boris Baryshnikov
Technical Reviewers: Louis Davidson, Mark Pohto, Jay (In-Jerng) Choe
Published: June 2009
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.
The Resource Governor is a new feature in the Microsoft SQL Server 2008 Enterprise. It provides very powerful and flexible controls to dictate and monitor how a SQL Server instance behaves in terms of CPU, memory and response time.
This white paper is targeted at IT professionals and database administrators responsible for managing scale, concurrency, high availability, consolidation, virtualization, or service level agreements for the SQL Server instances in their production environments. In this paper you are shown various ways in which you can use the Resource Governor to analyze and streamline the way resources are utilized within your SQL Server instances, by explaining:
Abstract courtesy : Microsoft
Reference : Pinal Dave (http://blog.SQLAuthority.com)