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