17.05 - Net: Work Mailbox Queue Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

These columns identify the virtual processor work mailbox queue length where requested work awaits the allocation of a process to perform the work.

Column Name Mode Description Data Type
MsgWorkQLen track Total number of work requests waiting at the current time. FLOAT
MsgWorkQLenMax max Maximum number of work requests waiting during each log interval.

The Max count, unlike the MsgWorkQLen field, tracks the maximum count over the log period. Therefore, the MsgWorkQLen field can be zero even though the Max count can be non-zero over the log period.

FLOAT