Net: Net Miscellaneous Contention Management 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 some additional contention management not addressed in the other contention management areas.

Column Name Mode Description Data Type
NetBrdWindowOverrun count Broadcast window overruns on all Bynets.
This column is net-specific, that is, it relates to each specific Bynet. On a single-node system, net-specific statistics are not meaningful and are always zero
FLOAT
NetMrgBufWaits count Number of times an IOP task encountered an empty row-block buffer on all Bynets. FLOAT
NetMrgHeapFails count Number of times a merge operation heap space request failed. FLOAT
NetMrgHeapRequests count Number of times a merge operation requested heap space. FLOAT
NetMsgFCSleep count Number of times a transmitter process was put to sleep because it was flow controlled. FLOAT