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 Resource Pools

To drop a resource pool 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 Resource Pools folder to list the resource pools defined.

3. Right-click the resource pool you want to drop and select Delete.

4. In the Delete Object window, the resource pool is listed in the Object to Be Deleted list. Click OK to confirm the deletion.

To drop a resource pool using T-SQL, use the DROP RESOURCE POOL command:

DROP RESOURCE POOL OLTPPOOLALTER RESOURCE GOVERNOR RECONFIGUREgo

You cannot drop a resource pool if any workload groups are still assigned to the resource pool. You need to drop ...

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