Resource Pools (SQL Server)

A resource pool represents the physical resources of the server. PowerDesigner models resource pools as extended objects with a stereotype of <<ResourcePool>>.

Creating a Resource Pool

You can create a resource pool in any of the following ways:

Select Model > Resource Pools to access the List of Resource pools, and click the Add a Row tool.
Right-click the model (or a package) in the Browser, and select New > Resource Pool.

Resource Pool Properties

You can modify an object's properties from its property sheet. To open a resource pool property sheet, double-click its Browser entry.

The following extended attributes are available on the Microsoft tab:

Name	Description
CPU percent Min	Specifies the guaranteed average CPU bandwidth for all requests in the resource pool when there is CPU contention. The value is an integer, with a default setting of 0. Scripting name: MinCpuPercent
CPU percent Max	Specifies the maximum average CPU bandwidth that all requests in resource pool will receive when there is CPU contention. The value is an integer, with a default setting of 100. Scripting name: MaxCpuPercent
Memory percent Min	Specifies the minimum amount of memory reserved for this resource pool that can not be shared with other resource pools. The value is an integer, with a default setting of 0. Scripting name: MinMemoryPercent
Memory percent Max	Specifies the total server memory that can be used by requests in this resource pool. The value is an integer, with a default setting of 100. Scripting name: MaxMemoryPercent