| title | DROP RESOURCE POOL (Transact-SQL) | ||
|---|---|---|---|
| description | DROP RESOURCE POOL (Transact-SQL) | ||
| author | WilliamDAssafMSFT | ||
| ms.author | wiassaf | ||
| ms.reviewer | dfurman | ||
| ms.date | 02/17/2025 | ||
| ms.service | sql | ||
| ms.subservice | t-sql | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
Deletes a user-defined resource governor resource pool for a [!INCLUDEssDE] instance.
Note
To modify resource governor configuration in [!INCLUDEssazuremi-md.md], you must be in the context of the master database on the primary replica.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
DROP RESOURCE POOL pool_name
[ ; ]
Is the name of an existing user-defined resource pool.
You can't drop a resource pool if it contains any workload groups.
You can't drop the built-in default and internal pools.
For more information, see Resource governor and Resource governor resource pool.
Requires the CONTROL SERVER permission.
The following example deletes the resource pool named big_pool and makes the new configuration effective.
DROP RESOURCE POOL big_pool;
ALTER RESOURCE GOVERNOR RECONFIGURE;