O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required