Tuning OnLine

• OLTP Run 1 Poll Thread Per CPU VP
• DSS Be Sure The Engine Is Using Light Scans
  • onstat -g lsc
  • Tables Must Be > Size Of Buffer Pool
  • Dirty Read Isolation
  • Performance Affected By RA_PAGES, RA_THRESHOLD

Previous slide

Next slide

Back to first slide

View graphic version