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.

   Nóta

   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.

SQL

DROP RESOURCE POOL poolAdhoc;

ALTER RESOURCE GOVERNOR RECONFIGURE;

Related content

• Resource governor
• Resource governor resource pool
• Create a resource pool
• Change resource pool settings
• Resource governor workload group
• Resource governor classifier function
• DROP WORKLOAD GROUP
• DROP RESOURCE POOL
• ALTER RESOURCE GOVERNOR
• DROP EXTERNAL RESOURCE POOL
• CREATE EXTERNAL RESOURCE POOL
• ALTER EXTERNAL RESOURCE POOL