Skip to content

delete-a-resource-pool.md

Latest commit

 

History

History
83 lines (58 loc) · 3.79 KB

delete-a-resource-pool.md

File metadata and controls

83 lines (58 loc) · 3.79 KB
title Delete a Resource Pool
description Learn how to delete a resource pool using either SQL Server Management Studio or Transact-SQL.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer dfurman
ms.date 01/02/2025
ms.service sql
ms.subservice performance
ms.topic how-to
helpviewer_keywords
Resource Governor, resource pool delete
resource pools [SQL Server], delete
monikerRange >= 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 SQL Server Management Studio (SSMS):

  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