Buffer Pool Performance

• HiperPools
  – How do you know when they will help?
  – How do you know if they are helping?
  – Castout – Yes or NO?
  – DSNDB07 considerations
  – HPSEQT
  – How much memory is available
  – 9672 CMOS considerations
  – ADMF 8% more efficient than MVPG
  – Cost of Page movement

Hiperpools provide the greatest benefit (generally) for pools dedicated to randomly accessed objects, that have a low update intensity.

Systems running on 9672 processors have no real overall benefit by having large amounts of memory configured as Expanded and using HPs. Since memory is just memory on these machines, it is more beneficial to have most configured as REAL, and just use standard VPs.