Edit

Share via

Delete a resource pool

Applies to: SQL Server Azure SQL Managed Instance

You can delete a resource pool by using either SQL Server Management Studio or Transact-SQL.

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:

  1. In SQL Server Management Studio, 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 Transact-SQL:

  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