BufferPool Statistical Analysis

BufferPool Statistical Analysis

Number of SetW (Updates)............170,158

Number of Pages Written..............73,624 20.5 Pages per Sec

Number of Sync Pages Written .........100 0.1% of Pages Written

Number of ASync Pages Written ......73,524 99.9% of Pages Written

Number of Pages per Write I/O..........1.6

Number of Write I/Os.................45,719 12.7 I/Os per Sec

Number of Sync Write I/Os.............100 0.2% of Write I/Os

Number of ASync Write I/Os..........45,619 99.8% of Write I/Os

Delay of Sync Write I/Os...............7 Avg. MSeconds (Max 66)

Delay of ASync Write I/Os...............4 Avg. MSeconds (Max 231)

Previous slide

Next slide

Back to the first slide

View Graphic Version

Continuing with the analysis of pool level information.