Create a Resource Pool
You can create a resource pool by using SQL Server Management Studio or Transact-SQL.
Before you begin: Limitations and Restrictions, Permissions
To create a resource pool, using: SQL Server Management Studio, Transact-SQL
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.
[Top]
Permissions
Creating a resource pool requires CONTROL SERVER permission.
[Top]
Create a Resource Pool Using SQL Server Management Studio
To create a resource pool by using SQL Server Management Studio
In SQL Server Management Studio, open Object Explorer and recursively expand the Management node down to and including Resource Governor.
Right-click Resource Governor, and then click Properties.
In the Resource pools grid, click the first column in the empty row. This column is labeled with an asterisk (*).
Double-click the empty cell in the Name column. Type in the name that you want to use for the resource pool.
Click or double-click any other cells in the row you want to change, and enter the new values.
To save the changes, click OK
Create a Resource Pool Using Transact-SQL
To create a resource pool by using Transact-SQL
Run the CREATE RESOURCE POOL statement specifying the property values to be set.
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
[Top]
See Also
Reference
CREATE RESOURCE POOL (Transact-SQL)
ALTER RESOURCE GOVERNOR (Transact-SQL)
Concepts
Resource Governor Resource Pool
Configure Resource Governor Using a Template