Client Case Study.....Tune the Pools The Standard Shotgun Approach

Client Case Study.....Tune the Pools The Standard Shotgun Approach

• The Initial 240 Megabytes of BP0 became.....
  • BP0.....60 Meg - 15,000 Buffers Catalog & Large Tables
  • BP1.....80 Meg - 20,000 Buffers Indexes
  • BP2.....80 Meg - 20,000 Buffers Sort/Work
• Average Transaction I/O Wait dropped to .1 Secs
• Saved 20 Megabytes of Storage

Previous slide

Next slide

Back to the first slide

View Graphic Version

The initial shotgun tuning efforts showed dramatic performance improvements, while using Less Memory.

Actually, later tuning exercises have shown it’s usually better to leave the Indexes in BP0 with the catalog and directory...since indexes (should be) are usually accessed randomly.