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