Skip to content

change-resource-pool-settings.md

Latest commit

 

History

History
78 lines (57 loc) · 4.04 KB

change-resource-pool-settings.md

File metadata and controls

78 lines (57 loc) · 4.04 KB
title Change Resource Pool Settings | Microsoft Docs
ms.custom
ms.date 03/17/2016
ms.prod sql
ms.reviewer
ms.technology performance
ms.topic conceptual
helpviewer_keywords
Resource Governor, resource pool alter
resource pools [SQL Server], alter
ms.assetid 49438285-a011-4dac-bd4f-f35cd90fda61
author julieMSFT
ms.author jrasnick

Change Resource Pool Settings

[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md]

You can change resource pool settings by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

Before You Begin

Limitations and Restrictions

The maximum CPU percentage must be equal to or higher than the minimum CPU percentage. The maximum memory percentage must be equal to or higher than the minimum memory percentage.

The sums of the minimum CPU percentages and minimum memory percentages for all resource pools must not exceed 100.

Permissions

Changing resource pool settings requires CONTROL SERVER permission.

Change Resource Pool Settings Using SQL Server Management Studio

To change resource pool settings by using [!INCLUDEssManStudioFull]

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

  2. Right-click the resource pool to be modified, and then click Properties.

  3. In the Resource Governor Properties page, select the row for the resource pool in the Resource pools grid if it is not automatically selected.

  4. Click or double-click the cells in the row to be changed, and enter the new values.

  5. To save the changes, click OK

Change Resource Pool Settings Using Transact-SQL

To change resource pool settings by using [!INCLUDEtsql]

  1. Run the ALTER RESOURCE POOL or ALTER EXTERNAL RESOURCE POOL statement specifying the property values to be changed.

  2. Run the ALTER RESOURCE GOVERNOR RECONFIGURE statement.

Example (Transact-SQL)

The following example changes the max CPU percentage setting for the resource pool named poolAdhoc.

ALTER RESOURCE POOL poolAdhoc  
WITH (MAX_CPU_PERCENT = 25);  
GO  
ALTER RESOURCE GOVERNOR RECONFIGURE;  
GO

See Also

Resource Governor
Enable Resource Governor
Create a Resource Pool
Delete a Resource Pool
Resource Governor Workload Group
Resource Governor Classifier Function
ALTER RESOURCE POOL (Transact-SQL)
ALTER RESOURCE GOVERNOR (Transact-SQL)
CREATE EXTERNAL RESOURCE POOL (Transact-SQL)
ALTER EXTERNAL RESOURCE POOL (Transact-SQL)