Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Delete a Resource Pool
Collapse the table of content
Expand the table of content

Delete a Resource Pool

 

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

You cannot delete a resource pool if it contains workload groups.

You cannot delete the Resource Governor default or internal resource pools. You cannot delete a resource pool if it contains workload groups. For more information, see Delete a Workload Group.

Deleting a resource pool requires CONTROL SERVER permission.

To delete a resource pool by using SQL Server Management Studio

  1. In SQL Server Management Studio, open Object Explorer and recursively expand the Management node down to and including Resource Governor.

  2. Right-click the resource pool to be deleted, and then click Delete.

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

    System_CAPS_noteNote

    If the resource pool that you are trying to delete contains a workload group, this action will fail.

To delete a resource pool by using Transact-SQL

  1. Run the DROP RESOURCE POOL statement specifying the name of the resource pool to delete.

  2. Run the ALTER RESOURCE GOVERNOR RECONFIGURE statement.

The following example drops a workload group named poolAdhoc.

DROP RESOURCE POOL poolAdhoc;
GO
ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

Community Additions

ADD
Show:
© 2015 Microsoft