The I/O Activity tab on the Database Analysis drilldown provides a summary of I/O activity on the database or partition you are monitoring. The graphs track of rates for the following:
Reads and writes that involve the buffer pool
Direct reads and writes, which do not go through the buffer pool, but access the database directly
The I/O Activity tab contains the following graphs, which keep track of database I/O rates over consecutive monitoring intervals:
High rates depicted on the graphs for the following activities might be indications of performance degradation since these activities involve disk I/O and slow-downs in query processing:
Physical read rates (compared to logical read rates)
Synchronous read or write rates
Direct I/O rates for a database
If you need to investigate high rates for any of these activities, refer to the graphs on the I/O Activity tab in the following drilldowns:
Client Application Analysis drilldown—To identify the applications that are contributing to high I/O activity rates
Tablespaces drilldown—To pinpoint the tablespaces on which the high I/O activity is occurring
Buffer Pools drilldown—To identify those buffer pools that are not being used effectively to offset I/O on the database
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
