Application BufferPool Data

Application BufferPool Data

BuffPool ---0-- ---1-- ---2--

Get Page 4 851 22

Updates 2 0 0

Lst Pref 0 0 0

Seq Pref 0 24 0

Dyn Pref 0 0 0

PgsRdAsy 0 143 0

SyncRead 2 6 0

Write 0 0 0

HplWrite 0 0 0

Fail 0 0 0

Hpl Read 0 0 0

Fail 0 0 0

PgsRd 0 0 0

82.7% Hit Ratio

<<< Note New Data

<<< Note New Data

Previous slide

Next slide

Back to the first slide

View Graphic Version

As previously mentioned, we can calculate the hit ratio at the application level because of the new instrumentation. Also note the HP information that is available at this level.

Hit Ratio = (GP-PagesRd)/GP