Skip to content

create-a-resource-pool.md

Latest commit

 

History

History
79 lines (58 loc) · 3.58 KB

create-a-resource-pool.md

File metadata and controls

79 lines (58 loc) · 3.58 KB
title Create a Resource Pool | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology performance
ms.topic conceptual
helpviewer_keywords
resource pools [SQL Server], create
Resource Governor, resource pool create
ms.assetid 44dd0567-a4c8-4c72-89ff-e76f6ddef344
author MikeRayMSFT
ms.author mikeray
manager craigg

Create a Resource Pool

You can create a resource pool 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

Creating a resource pool requires CONTROL SERVER permission.

Create a Resource Pool Using SQL Server Management Studio

To create a resource pool by using [!INCLUDEssManStudioFull]

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

  2. Right-click Resource Governor, and then click Properties.

  3. In the Resource pools grid, click the first column in the empty row. This column is labeled with an asterisk (*).

  4. Double-click the empty cell in the Name column. Type in the name that you want to use for the resource pool.

  5. Click or double-click any other cells in the row you want to change, and enter the new values.

  6. To save the changes, click OK

Create a Resource Pool Using Transact-SQL

To create a resource pool by using [!INCLUDEtsql]

  1. Run the CREATE RESOURCE POOL statement specifying the property values to be set.

  2. Run the ALTER RESOURCE GOVERNOR RECONFIGURE statement.

Example (Transact-SQL)

The following example creates a resource pool named poolAdhoc.

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

See Also

Resource Governor
Enable Resource Governor
Resource Governor Resource Pool
Change Resource Pool Settings
Delete a Resource Pool
Configure Resource Governor Using a Template
Resource Governor Workload Group
Resource Governor Classifier Function
CREATE RESOURCE POOL (Transact-SQL)
ALTER RESOURCE GOVERNOR (Transact-SQL)