I/O Operations Overview

In the I/O operations menu, you can find a display of disk activities.

Prerequisites

Prerequisites

Procedure

In the Database Assistant, choose Current Status ® I/O Operations ®  Overview.

...

Result

The system displays an overview of the activities on the disks on which the volumes are stored. You can use the number of read and write accesses to determine how many I/O operations take place in your database. You can analyze in detail the processes that cause the I/O operations on the volumes.

·        If wait queues (Queue) are displayed for accesses to a disk area, this indicates a bottleneck when accessing this disk area.

·        Choose Goto ® I/O Details to display which thread accessed the individual volumes and to obtain information about the I/O wait queues for the individual volumes.
You can use this display to find out whether there are bottlenecks in the I/O system. The columns
Queue Length and Maximum Queue Length provide information about whether there are currently or were previously large queues of I/O requests.

·        You can refresh the display.