What is Resource governor?

Submitted by: Administrator
Resource Governor enables the DBA for managing the work load of SQL Server and critical system resource consumption. The limits of CPU and memory which are the incoming sessions to the SQL Server will be controlled by Resource Governor.

The various scenarios that occur when sudden spike in CPU and memory utilization that result in slow responses for querying requests. The Resource Governor enables the DBA's to differentiate the workloads and allocates the shared resources which allow the available CPU and memory resources.
Submitted by: Administrator

Read Online MS SQL Server 2008 Job Interview Questions And Answers