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.