Physical Modeling › SQL Server 2008 Property Editors › Define a SQL Server 2008 Resource Pool

Previous Topic: Specify the Return Order for a Table Return Assembly Function

Next Topic: Define a Symmetric Key in SQL Server 2008

Define a SQL Server 2008 Resource Pool

You use resource pools in SQL Server 2008 to manage the resource policies for session requests. A workload group allows the aggregate monitoring of resource consumption and the application of a uniform policy to all the requests in the group.

Use the SQL Server Resource Pool Editor in a SQL Server 2008 physical model to define the physical resource parameters for a virtual resource pool within a SQL Server instance.

To define a SQL Server resource pool

  1. Click Target - SQL Server, Resource Pools on the Model menu.

    The SQL Server Resource Pool Editor opens.

  2. Select the resource pool in the Navigation Grid that you want to define and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new resource pool. Use the Enter filter text box to filter a very large list of resource pools to quickly locate the one that you want to define.

    Name

    Specifies the name of the resource pool. You can change the name of the resource pool in this field.

    Minimum CPU Percentage

    Specifies the guaranteed average CPU bandwidth for all requests in the resource pool when there is CPU contention.

    Maximum CPU Percentage

    Specifies the maximum average CPU bandwidth for all requests in the resource pool when there is CPU contention.

    Minimum Memory Percentage

    Specifies the guaranteed minimum amount of memory for all requests in the resource pool.

    Maximum Memory Percentage

    Specifies the maximum percentage of total memory that can be used by requests in the resource pool.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

  3. (Optional) Click the Comment tab and enter any comments that you want to associate with the resource pool.
  4. (Optional) Click the Where Used tab to view where the resource pool is used in the model.
  5. (Optional) Click the UDP tab to work with user-defined properties for the resource pool.
  6. (Optional) Click the Notes tab to view history information and view or edit user notes.
  7. Click Close.

    The resource pool is defined and the SQL Server Resource Pool Editor closes.