jitendra.padhiyar (6/14/2013)

---

Hello Masters,

I had SQL Server 2005 SP3 on my server and from yesterday I got an alert that "Buffer cache hit ratio is less than 10%" I monitored it for 2-3 hours, also checked memory which is more than sufficient (32GB). AWE is also enabled. Checked Error logs and event logs not seen any errors too. Whats the factor that get down this buffer cache hit ration down ?

How can i up this to its normal count ? Please advice.

BR,

Jitendra