Skip to main content

Top IO Activity Tables

  1. Another graph in the left bottom right section, shows the top 10 tables involved maximum IO activity.
  2. The activity usually includes read and write disk blocks during a query execution.
  3. A high IO 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.
    2. You may also want to consider defining more indexes on the able as you see fit.

Source`