Buffer Pool Asynchronous Read Requests



Snapshot Level
Database
Table Space


Logical Data Grouping
dbase
tablespace
bp_info


Monitor Switch
Buffer Pool
Buffer Pool
Buffer Pool


Resettable


Yes


 


Event Type
Database
Table Space


Logical Data Grouping
db_event
tablespace_event


 


Element Name
Element Type



pool_async_data_read_reqs
counter

 

Description:  The number of asynchronous read requests.

Usage:  To calculate the average number of data pages read per asynchronous request, use the following formula:

 buffer pool asynchronous data reads / buffer pool asynchronous read requests

This average can help you determine the amount of asynchronous I/O done in each interaction with the prefetcher.