What is good number for bufwaits?

Posted in 1998

Colburn — Tue, 12 May 1998 09:45:49 -0400 — source: Informix-list mailing list archive (1991-1998)

I just read the latest Informix TechNotes and they suggest bufwaits should be 0. Mine is at 136,923 (server has only been up 7 hours). My buffers are at 50,000 for 75 users on a 2Gb database on IUS 9.13. My read a write cache rates are 99% & 95%. My readaheads add up to my RS_pagesused. The only thing I could find was an article stating that it might be too small a difference between RA_PAGES (set to 8) and RA_THRESHOLD (was 4, I set to 1 last night). My change did not seem to make a difference. Is this number excessive? If so, what else should I look at? Thanks, Tim