MV_RESOURCE_POOL_STATUS

This view contains information about the status of resource pools aggregating this information across all nodes in the cluster.

The view LMV_RESOURCE_POOL_STATUS provides the same resource pool status information as a local view for a specific node.

Column Name

Description

NODE_ID

The ID of the related node.

POOL_NAME

The name of a given resource pool.

RUNNING_QUERIES

The number of queries running on a given resource pool. This statistic is dependent on the current state of the server.

QUEUEING_QUERIES

The number of queries queued for a given resource pool. This statistic is dependent on the current state of the server.

KILLED_QUERIES

The number of queries killed on a given resource pool. This statistic is cumulative from the start of the server for that node.

FINISHED_QUERIES

The number of queries finished on a given resource pool. This statistic is cumulative from the start of the server for that node.

TOTAL_QUEUE_TIME_US

The historical total queue time for a given resource pool. This statistic is cumulative from the start of the server for that node.

AVERAGE_QUEUE_TIME_US

The historical average queue time for a given resource pool. This statistic is cumulative from the start of the server for that node.

CPU_AFFINITY_MASK

A boolean mask showing which CPU is designated for the queries in a given resource pool.

MEMORY_USAGE_BYTES

The amount of memory (in bytes) currently utilized by the associated resource pool. It is useful for monitoring resource allocation and detecting memory bottlenecks within the resource pools.

Last modified:

Was this article helpful?