RESOURCE_POOLS

This view contains information about resource pools.

For more information about these fields, see CREATE RESOURCE POOL.

Column Name

Description

POOL_NAME

The name of a given resource pool.

MEMORY_PERCENTAGE

The percentage of available memory that the given resource pool is allowed to use.

QUERY_TIMEOUT

The number of seconds after which a resource pool is set to cancel queries.

MAX_CONCURRENCY

The maximum number of concurrent queries that can be run across all aggregators at a time for a given resource pool.

SOFT_CPU_LIMIT_PERCENTAGE

An integer between 1 to 100. CPU usage for users can be limited from 1% - 100% of available processing capacity.

HARD_CPU_LIMIT_PERCENTAGE

An integer between 1 to 100. CPU usage for users can be limited from 1% - 100% of available processing capacity.

MAX_QUEUE_DEPTH

The maximum number of queries that will be queued when MAX_CONCURRENCY is exceeded.

Last modified: August 29, 2022

Was this article helpful?