concept resource Governor in category sql server
appears as: Resource Governor

This is an excerpt from Manning's book SQL Server 2008 Administration in Action.
Resource Governor— While SQL Server 2005 included coarse-grained control of server resource usage via instance memory caps, CPU affinity, and Query Governor Cost Limit, SQL Server 2008 permits the definition of resource pools into which incoming connections are classified via group membership. As you’ll see in chapter 16, each pool’s memory and CPU usage can be constrained, therefore enabling more predictable performance, particularly for mixed-purpose SQL Server instances—for example, a data entry environment that’s also used for reporting purposes.
A classic example of this is a SQL Server instance used for both reporting and data entry. In such a case, performance for data entry users may be fine until someone decides to run a large report, at which time data entry performance grinds to a halt. Resource Governor is purpose built to address problems of this type.