Microsoft® SQL Server 2012 Unleashed

Deleting Workload Groups

You can delete a workload group or resource pool by using SQL Server Management Studio or T-SQL. To drop a workload group in SSMS, follow these steps:

1. Expand the Management node in Object Explorer and expand the Resource Governor node to display the Resource Pools folder.

2. Expand the node of the resource pool where the workload group is defined to display the Workload Groups folder.

3. Expand the Workload Groups folder to list the workload groups.

4. Right-click the workload group you want to drop and select Delete.

5. In the Delete Object window, the Workload Group is listed in the Object to Be Deleted list. Click OK to confirm the deletion.

To drop a workload group using T-SQL, use the DROP WORKLOAD GROUP command: ...