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