ALTER RESOURCE POOL (Transact-SQL)
Changes an existing Resource Governor resource pool configuration.
Transact-SQL Syntax Conventions.The introduction is required.
MAX_CPU_PERCENT and MAX_MEMORY_PERCENT must be greater than or equal to MIN_CPU_PERCENT and MIN_MEMORY_PERCENT, respectively.
The sums of MIN_CPU_PERCENT and MIN_MEMORY_PERCENT for all the resource pools must not exceed 100.
When you are executing DDL statements, we recommend that you be familiar with Resource Governor states. For more information, see Resource Governor States.
The following example keeps all the default resource pool settings on the default pool except for MAX_CPU_PERCENT, which is changed to 25.
ALTER RESOURCE POOL "default" WITH ( MAX_CPU_PERCENT = 25) GO ALTER RESOURCE GOVERNOR RECONFIGURE GO