Posted by Marek Wierzbicki on 03/01/06 15:05

I think I have problem with so greedy cache.


Buffer manager shows, that:
Hit ratio is often over 96%
Page life expectacy is about 15-50 sec
Pages read/sec is very similar to readahead pages (often bigger)

And I have trouble with disk array, which have no power to transfer all data
asked by SQL (often they are disk queue, and SQL can't answer at once for
simple select)

So I think its better set cache to not read so much readahead pages.

But I don't know how to do it. Is it possible?

Marek

[Back to original message]