Buffer Free Pages
I've recently started using SQL Monitor and am a bit confused by the Buffer Free Pages metric. We occasionally get performance issues on our low usage website (SQL Server 2008 R2 Standard) and there appears to be a correlation between the performance issues and the Buffer Free Pages value. However, as far as I can tell, the performance is bad when BFP is high (above say 10,000). Can anyone explain what I am seeing and/or point me at a different metric to monitor that would be more useful? At the moment I'm assuming that the rise in BFP (which I would otherwise expect to be a good thing) is actually a symptom of a problem elsewhere but I'm not sure where to look.