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 ...
Get Microsoft® SQL Server 2012 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.
