BufferPool Statistical Analysis

Number of Pages Read..............1,553,174 431.5 Pages per Second

Number of Sync Pages Read.........393,989 25.4% of Pages Read

Number of SPref Pages Read.........999,889 64.4% of Pages Read

Number of LPref Pages Read..........14,853 1.0% of Pages Read

Number of DPref Pages Read.........144,443 9.3% of Pages Read

Number of Read I/Os.................442,966 123.1 I/Os per Second

Number of Sync Read I/Os.........393,989 88.9% of Read I/Os

Number of SPref Read I/Os..........32,127 7.3% of Read I/Os

Number of LPref Read I/Os..........11,853 2.7% of Read I/Os

Number of DPref Read I/Os...........4,997 1.1% of Read I/Os

Delay of Sync Read I/Os..............14 Avg. MSeconds (Max 249)

Delay of SPref Read I/Os..............36 Avg. MSeconds (Max 250)

Delay of Lpref Read I/Os..............43 Avg. MSeconds (Max 249)

Delay of DPref Read I/Os..............44 Avg. MSeconds (Max 243)

Previous slide Next slide Back to the first slide View Graphic Version

Notes:

When we utilize the 6 & 7 read records, we obtain the true system hit ratio. While the application hit ratio is important because it indicates application performance, this is across all application plans and can hide application performance problems caused by synchronous I/O wait times.

These types of statistics can easily be produced by writing some code...using SAS, PL/1, Assembler, or even in REXX.

The analysis is continued on the next slide.