Great SQL Server Debates: Buffer Cache Hit Ratio
Posted by: Simple Talk,
on 18 Jan 2012 |
View original | Bookmarked: 0 time(s)
One of the more popular counters used by DBAs to monitor SQL Server performance, the Buffer Cache Hit Ratio, is useless as a predictor of imminent performance problems. Worse, it can be misleading. Jonathan Kehayias demonstrates this convincingly with some simple tests....