# ALTER RESOURCE POOL

The `ALTER RESOURCE POOL` command changes the resource settings in an existing resource pool.

## Syntax

```sql

ALTER RESOURCE POOL pool_name SET (resource_setting [, ...n])

resource_setting:
    MEMORY_PERCENTAGE = percent
  | QUERY_MEMORY_PERCENTAGE
  | QUERY_TIMEOUT = seconds
  | SOFT_CPU_LIMIT_PERCENTAGE = percent
  | HARD_CPU_LIMIT_PERCENTAGE = percent
  | MAX_CONCURRENCY = integer
  | MAX_QUEUE_DEPTH = integer

```

For information on each resource setting, see [CREATE RESOURCE POOL](https://docs.singlestore.com/db/v9.1/reference/sql-reference/resource-pool-commands/create-resource-pool.md).

## Remarks

* You cannot alter the [built-in resource pools](https://docs.singlestore.com/db/v9.1/user-and-cluster-administration/use-the-workload-manager-and-set-resource-limits/set-resource-limits/resource-pool-basics/#section-idm4510351909488033483313104461.md).
* `CREATE POOL` or `DROP POOL` privileges are required for altering a resource pool.
* Changes made to a resource pool take effect immediately, but running queries in the pool won’t be killed if the pool currently exceeds its new memory limit.
* The resource pool settings `MEMORY_PERCENTAGE`, `QUERY_TIMEOUT`, `SOFT_CPU_LIMIT_PERCENTAGE`, `HARD_CPU_LIMIT_PERCENTAGE`, `MAX_CONCURRENCY`, and `MAX_QUEUE_DEPTH` in the resource pools `default_pool`, `system_auto`, and `system_optimizer_pool` are fixed. These settings cannot be changed.
* This command can be run on a master, or child aggregator (see [Node Requirements for SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).
* Refer to the [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Example

The following example alters resource limits in two resource pools.

Before altering the current limits for the resource pools, it is advisable to set the current limits to a lower value, to create headroom.

```sql
ALTER RESOURCE POOL executive SET HARD_CPU_LIMIT_PERCENTAGE = 10;
ALTER RESOURCE POOL general SET HARD_CPU_LIMIT_PERCENTAGE = 10;
ALTER RESOURCE POOL executive SET MEMORY_PERCENTAGE = 10;
ALTER RESOURCE POOL general SET MEMORY_PERCENTAGE = 10;

```

Now set the new resource limits, as required:

```sql
ALTER RESOURCE POOL executive SET HARD_CPU_LIMIT_PERCENTAGE = 75;
ALTER RESOURCE POOL general SET HARD_CPU_LIMIT_PERCENTAGE = 25;
ALTER RESOURCE POOL executive SET MEMORY_PERCENTAGE = 55;
ALTER RESOURCE POOL general SET MEMORY_PERCENTAGE = 45;
ALTER RESOURCE POOL executive SET QUERY_MEMORY_PERCENTAGE = 10;

```

## Related Topics

* For more information about using resource pools to specify resource limits, see [Set Resource Limits](https://docs.singlestore.com/db/v9.1/user-and-cluster-administration/use-the-workload-manager-and-set-resource-limits/set-resource-limits.md).

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/resource-pool-commands/alter-resource-pool/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/resource-pool-commands/alter-resource-pool/)

(An index of the documentation is available at /llms.txt)