Responsive Systems Company

Buffer Pool Performance

Buffer Pool Performance

  • System Hit Ratio (Getpages-SumOfPagesRead)/Getpages
    • Effect/Meaning of Negative Hit Ratios...
    • Effect and setting of VPSEQT
  • HP Retrieval Ratio PagesReadHP/PagesWrittenHP
    • Is a low ratio always bad, or can it be all right?
  • Pages Written per Write
    • Adjust VWTH and DWTH
  • I/O Rate per Second
    • System, Each Pool, Objects

ROTs

ROTs

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