MV_RESOURCE_POOL_STATUS

This view contains information about the status of resource pools.

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.

Last modified: August 29, 2022

Was this article helpful?