Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - Getting Started Guide

Database Analysis drilldown I/O Activity tab

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

Graphs

The I/O Activity tab contains the following graphs, which keep track of database I/O rates over consecutive monitoring intervals:

Data Read Rate

Index Read Rate

Index and Data Write Rates

Direct Read and Write Rates

Troubleshooting high I/O activity on the database

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

 

Related topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating