Change Resource Pool Settings
You can change resource pool settings by using SQL Server Management Studio or Transact-SQL.
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.
Changing resource pool settings requires CONTROL SERVER permission.
To change resource pool settings 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 Pools.
Right-click the resource pool to be modified, and then click Properties.
In the Resource Governor Properties page, select the row for the resource pool in the Resource pools grid if it is not automatically selected.
Click or double-click the cells in the row to be changed, and enter the new values.
To save the changes, click OK
To change resource pool settings by using Transact-SQL
Run the ALTER RESOURCE POOL statement specifying the property values to be changed.
Run the ALTER RESOURCE GOVERNOR RECONFIGURE statement.