Microsoft® SQL Server 2012 Unleashed

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:

Click here to view code image

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