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.

Was this article helpful?