Re: buffer cache hit ratio. LIO vs PIO
Originally posted by JMac
I came across a post on AskTom that seemed to contradict everything I've been told or read about tuning the buffer cache hit ratio and reducing Physical IO by aiming to get all queries satisfied by reading the blocks in the buffers.
Whats your view on LIP vs PIO and exactly what should we look for when tuning memory?
Wass wrong in that link???????
wont reducing ur LIO reduce ur PIO (most often than not it will)..
U shud look for ur CONSISTENT/DB BLOCK gets and reduce as much as possible..
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"