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: ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
