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.
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 ...