Skip to main content

Top Write Activity Tables

  1. Another graph in the left bottom right section, shows the top 10 tables involved maximum write activity.
  2. The activity usually includes count of disk blocks written during a query execution.
  3. A high write count indicates the usage of the table being high and strategy deficiency in storing data in the table.
    1. You may want to consider partitioning the table to reduce IO load on the DB system so that queries read lesser disk blocks and hence lesser IO thrashing.

Source