our sql server with 8gb of memory seems to be timing out. the advice I am getting is to add more memory. the question is how much? One guy says sql server will use all available memory "no matter how much you put it" (if a bad sp is running amok..).
is there a automated report I can run to advise me when memory use reaches 80%? do we need a third party program to monitor memory usage?