By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Troubleshooting SQL Buffer Cache Hit Ratio

P: n/a
This issue just happen recently. The buffer cache ratio went from > 90%
to 50% and has slowly been climbing back up over 8 hours or so. Its
currently @ 76%. Is this something I should take action on immediately?
It seems to be coming back to normal...

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(la******@pacbell.net) writes:
This issue just happen recently. The buffer cache ratio went from > 90%
to 50% and has slowly been climbing back up over 8 hours or so. Its
currently @ 76%. Is this something I should take action on immediately?
It seems to be coming back to normal...


Seems like there been some unsual event.

Maybe someone ran a bad query which required scanning of one or more
big tables, and this squeezed out data from the cache.

Someone might also have run DBCC DROPCLEANBUFFERS, and flushed the
cache entirely. But that case I would guess you would bave been down
to 0% for a short while.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.