Faisal Abdullah wrote:

>
> Our DefaultDbCachePages is commented out. So i guess we're running a
> default of 75 pages on our classic server. Is there a way to calculate
> the optimized value for this?

Sigh. No. Not in general. For a specific application, you can measure
the number of fetches & reads and guess whether pages are being released
from cache because the cache is full, then re-read later.


Regards,

Ann