Skip to content

Latest commit

 

History

History
83 lines (58 loc) · 3.83 KB

delete-a-resource-pool.md

File metadata and controls

83 lines (58 loc) · 3.83 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
Delete a Resource Pool
Learn how to delete a resource pool using either SQL Server Management Studio or Transact-SQL.
WilliamDAssafMSFT
wiassaf
dfurman
01/02/2025
sql
performance
how-to
Resource Governor, resource pool delete
resource pools [SQL Server], delete
>= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current

Delete a resource pool

[!INCLUDE SQL Server SQL MI]

You can delete a resource pool by using either [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

Limitations

  • You can't delete the built-in default or internal resource pools.
  • You can't delete a resource pool if it contains workload groups. For more information, see Delete a workload group.

Permissions

Deleting a resource pool requires CONTROL SERVER permission.

Delete a resource pool using Object Explorer

To delete a resource pool using [[!INCLUDEssManStudioFull]](../../ssms/download-sql-server-management-studio-ssms.md):

  1. In [!INCLUDEssManStudioFull], open Object Explorer and expand the Management node down to and including Resource Governor.

  2. Open the context menu of the resource pool to be deleted and select Delete.

  3. In the Delete Object window, the resource pool is listed in the Object to be deleted list. To delete the resource pool, select OK.

    [!NOTE] If the resource pool that you are trying to delete contains a workload group, this action fails.

Delete a resource pool using Transact-SQL

To delete a resource pool using [!INCLUDEtsql]:

  1. Execute the DROP RESOURCE POOL or DROP EXTERNAL RESOURCE POOL statement specifying the name of the resource pool to delete.
  2. Execute the ALTER RESOURCE GOVERNOR RECONFIGURE statement for the changes to take effect.

Example

The following example deletes a resource pool named poolAdhoc and makes the new configuration effective.

DROP RESOURCE POOL poolAdhoc;

ALTER RESOURCE GOVERNOR RECONFIGURE;

Related content