Field

Description

I/O

Number of I/O Servers

Number of I/O servers that read data asynchronously from the hard disk into the buffer pool

Number of I/O Cleaners

Number of I/O cleaners that write data asynchronously from the buffer pool to the hard disk

Average Time

Asynchronous Physical Reads

Average time in milliseconds required by the I/O servers to read a page from disk and write it to the buffer pool

Asynchronous Physical Writes

Average time in milliseconds required by the I/O cleaners to read a page from the buffer pool and write it to the hard disk

Data

Asynchronous Physical Reads

Number of data pages that were read asynchronously from disk and written to the buffer pool by the I/O servers (prefetch)

Asynchronous Physical Writes

Number of data pages that were written asynchronously from buffer pool to disk (I/O cleaners)

Asynchronous Read Requests

Number of asynchronous data read requests

Index

Asynchronous Physical Reads

Number of index pages that were read asynchronously from disk and written to the buffer pool by the I/O servers (prefetch)

Asynchronous Physical Writes

Number of index pages that were written asynchronously from buffer pool to disk (I/O cleaners)

Asynchronous Read Requests

Number of asynchronous index read requests