Export (0) Print
Expand All

How to: Move Workload Groups Between Resource Pools (Transact-SQL)

This topic shows how you can use Transact-SQL to move a workload group to a different resource pool. You might decide that a workload group should be in a resource pool that has different configuration settings, or you might want to move workload groups out of a resource pool so that you can drop the resource pool.

To move a workload group to a different pool

  • In Query Editor in SQL Server Management Studio, issue the following statements to move the workload group named adHoc to the Default pool.

    ALTER WORKLOAD GROUP adHoc
    USING [default];
    GO
    ALTER RESOURCE GOVERNOR RECONFIGURE
    GO
    

Community Additions

ADD
Show:
© 2014 Microsoft