BufferPool Performance Analysis Beyond the Basic Hit Ratio.....

BufferPool Performance Analysis Beyond the Basic Hit Ratio.....

• Performance Trace Records:
  • IFCID 198 Getpage/Relpage Data
  • IFCID 006 Start I/O, Type of Read Request
  • IFCID 007 Complete I/O, Number of Pages Read
    • I/O Type, # Pages Read
  • IFCID 008 Start I/O, Write Request
  • IFCID 009,010 Complete I/O, Number of Pages Written

Previous slide

Next slide

Back to the first slide

View Graphic Version

Since we are primarily concerned with READ performance, as it effects application response time, we need these three IFCIDs.

If we are also concerned with write activity, we also want the 8, 9, and 10 records.