Monitoring System Resources for Concurrent Use
When running in a multi-user environment, you may have several processes competing concurrently for system resources. Use the built-in GENERAL resource pool to provide resources in a multi-user environment. The GENERAL pool is preconfigured based on your system's RAM and machine cores. You can customize the GENERAL pool or define new resource pools and configure them for memory usage, concurrency, and query priority.
To monitor use of system resources over time, query the following system tables.
System Table Name | Description |
---|---|
RESOURCE_ACQUISITIONS | Details about each resource (memory, open file handles, threads) acquired by each request for each resource pool in the system. |
RESOURCE_POOL_DEFAULTS | Default values for parameters in each internal and user-defined resource pool. |
RESOURCE_POOL_STATUS | Configuration settings of the various resource pools in the system, including internal pools. |
RESOURCE_POOLS | Information about settings with which each resource pool was configured. |
RESOURCE_QUEUES | Information about requests that are pending for various resource pools. |
RESOURCE_REJECTIONS | Information about requests for resources that are rejected by the Resource Manager. |
RESOURCE_REJECTION_DETAILS | Entries for each resource request that the Vertica database denies. This information is useful for determining if there are resource space issues and which users/pools encounter problems. |
SYSTEM_RESOURCE_USAGE | History about system resources, such as memory, CPU, network, disk, I/O. |
For more information about managing resource pools, see Best Practices for Managing Workload Resources in the Administrator's Guide.