Share via

  • Article

How to: Change Resource Pool or Workload Group Settings (SQL Server Management Studio)

You can change resource pool or workload group settings by using SQL Server Management Studio. Use the following steps to change the settings for a resource pool named poolAdmin and a workload group named groupAdmin.

Change resource pool settings

  1. In Object Explorer, recursively open the Management node down to and including Resource Pools.

  2. Right-click poolAdmin, and then click Properties.

  3. In the Resource Governor Properties page, select the row for poolAdmin in the Resource Pools grid if it is not automatically selected.

  4. Double-click the cell in the Maximum CPU% column, and then enter 50 as the new value.

  5. Double-click the cell in the Maximum Memory % column, and then enter 50 as the new value.

  6. To save the changes, click OK.

Change workload group settings

  1. In Object Explorer, open the Workload Groups folder under poolAdmin.

  2. Right-click groupAdmin, and then click Properties.

  3. In the Resource Governor Properties page, select the row for groupAdmin in the Workload groups for resource pool grid if it is not automatically selected.

  4. Open the list for Importance and change the setting from the default value of Medium to Low.

  5. Double-click the cell for Memory Grant, and then change the default value of 25 to 10.

  6. To save the changes, click OK