Originally posted by DaPi
Jodie, that's a nice little case study.

- The ratio did the job of signalling a potential problem.
- You looked at the real cause of the low ratio and fixed the problem (not the symptom). You might have postponed an upgrade by doing this.
- You understand that 88% is "healthy" for that db - so if you see it at 50% later you know it's gone "sick" (perhaps).
Also, you could look at cache advice to tell you whether you would benefit from

i) a little more RAM all round
ii) reallocating somememory from KEEP to RECYCLE, or vice versa.

Don't forget that cacheadice works at the KEEP/RECYCLE etc. level, as well as for the whole buffer cache.