Did You Know? SQL Server 2008 includes Resource Governor
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
Check out a screencast about the new Resource Governor feature in SQL Server 2008 via MSN Video below, or if you prefer Youtube or download.