• Article

How to: Create a Workload Group (SQL Server Management Studio)

You can create a workload group by using SQL Server Management Studio. Use the following steps to create a workload group named groupAdmin. This group uses the default settings provided by Resource Governor and will be in the resource pool named poolAdmin. For more information, see How to: Create a Resource Pool (SQL Server Management Studio).

To create a workload group.

  1. In Object Explorer, recursively expand the Management node down to and including Resource Governor.

  2. Right-click Resource Governor, and then click Properties. This opens the Resource Governor Properties page.

  3. In the Resource pools grid, click the first column for the poolAdmin row. A corresponding empty row is created in Workload groups for resource pool.

  4. Double-click the empty cell in the Name column for the empty workload group row. Type in the name you want to use for the workload group. For this example use the name groupAdmin.

  5. To exit the property page and create the workload group, click OK.

  6. You can use two methods to verify that the new group exists:

    1. Use Object Explorer. Recursively open the Resource Governor node down to and including poolAdmin. Expand the Workload Groups folder under poolAdmin, and you will see a folder named groupAdmin.

    2. Open the Resource Governor Properties page. In the Resource pools grid, click the first column for the poolAdmin row. The Workload groups for resource pool grid automatically displays the groups that are in the pool that you select.