Microsoft® SQL Server 2008 R2 Unleashed

Defining Workload Groups

After you define your resource pools, the next step is to create the workload groups and associate them with the appropriate resource pools. Multiple workgroups can be assigned to that same pool, but a workgroup cannot be assigned to multiple resource pools.

Creating Workload Groups in SSMS

To create a workload group in SSMS, perform the following steps:.

1. In Object Explorer, expand the Management node, right-click the Resource Governor node, and then click Properties to bring up the Resource Governor Properties page.

2. In the Resource Pools grid, click the row for the resource pool you want to create a workload group for (in this example, the ReportPool resource pool). This creates a new empty row in the Workload ...