17.00 - Net: Net Queues Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
These columns identify lengths of the various internal queues used by the network controllers.
  • NetSamples can be used to normalize all aggregated sampled statistics to an average queue-length basis.
  • Example: Dividing (NetPtPQueue/NetSamples) yields the average point-to-point queue length over all samples on all networks taken during this log interval.
  • All of the aggregated sampled statistics columns in the following table are net-specific, that is, they relate to each specific Bynet. On a single-node system, net-specific statistics are not meaningful and are always zero.
Column Name Mode Description Data Type
NetPtPQueue count Aggregated sample point-to-point normal priority queue length on all Bynets. FLOAT
NetBrdQueue count Aggregated sample broadcast normal priority queue length on all Bynets. FLOAT
NetPtPQueueMax max Maximum reported value of NetPtPQueue in this reporting interval. FLOAT
NetBrdQueueMax max Maximum reported value of NetBrdQueue in this reporting interval. FLOAT
NetHPBrdQueue count Aggregated sample broadcast high priority queue length on all networks. FLOAT
NetHPBrdQueueMax max Maximum value of NetHPBrdQueue in this reporting interval. FLOAT
NetPendMrgQueue count Current count of pending merges, regardless of which net. A merge may be queued for reasons such as:
  • The local IOP memory is saturated
  • System memory is trashing.
FLOAT
NetHPPtPQueue count Aggregated sample point-to point high priority queue length on all Bynets. FLOAT
NetHPPtPQueueMax max Maximum value of NetHPPtPQueue in this reporting interval. FLOAT