• Article

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