Net: Net Queues Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢
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