With the introduction of SQL Server 2008 came Resource Governor. With this new feature, you can control resource allocations based on rules. Greg Larsen explains how to setup resource governor, how to use it and the limitations associated with this new resource allocation tool.

This story continues at
http://www.databasejournal.com/featu...e-Governor.htm