Microsoft® SQL Server 2008 R2 Unleashed

Defining Resource Pools

When setting up a Resource Pool, you have to specify a name for the pool and set its properties. The properties available for a resource pool are

• Name—The name used to refer to the resource pool

• Minimum CPU %—The guaranteed average CPU bandwidth for all requests to the resource pool when there is CPU contention

• Maximum CPU %—The maximum average CPU bandwidth for all requests to the resource pool when there is CPU contention

• Min Memory %—The guaranteed minimum amount of memory reserved for the resource pool that cannot be shared with other resource pools

• Max Memory %—The total server memory that can be used by requests to the resource pool

Creating a Resource Pool in SSMS

The following steps walk you through ...