Resource Governor enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming requests.
In an environment where multiple distinct workloads are present on the same server, Resource Governor enables you to differentiate these workloads and allocate CPU and/or memory as they are requested, based on the limits that you specify. 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
• Unpredictable workload execution
• Setting workload priority
Channel: Science & Technology Uploaded: July 11, 2008 at 7:53 am Author:Vendoran
