Number of Rows Written to Tablequeues


 
Snapshot Level
Application

 
Logical Data Grouping
subsection

 
Monitor Switch
Statement

Resettable

No

 

Event Type
Statement

Logical Data Grouping
subsection_event

 

Element Name
Element Type

tq_rows_written
counter

 

Description:  Total number of rows written to tablequeues.

Usage:  If monitoring does not indicate that this number is increasing, then processing progress is not taking place.

If there is significant differences in this number between nodes, then some nodes may be over utilized while others are being under utilized.

If this number is large, then there is a lot of data being shipped between nodes, suggest that optimization might improve the access plan.