GilaMonster (10/11/2013)
George M Parker (10/11/2013)
To know whether your value is good or bad, you have to know what "normal" is. That means that you need to have a baseline value (or steady state as Jonathan refers to it) for PLE and then monitor for situations where it dips below that baseline value.This.
There are very few counters where there's a hard number that's good or bad. Numbers are normal or not normal for your instance.
I second "that" I personally enjoy using Red Gate SQL Monitor and then using their baseline comparisons. The key is definitely watching when PLE falls and knowing what processes occur during this time.
Why is it that people who can't take advice always insist on giving it? - James Bond, Casino Royale