I have a couple of SQL servers I need to take care of. I'm no DBA, but have done well doing the basics for many years.
One thing that does seem to catch me is that if there is a problem with a database, I usually don't figure it out until someone tells me there is something wrong. Often by that time there has been something wrong for a while so restoring from a backup isn't a great option.
While I try to be religious about looking through logs, it's tough sometimes to pick the problem through all the noise.
What are some good techniques and easy to use (hopefully) tools that will do a reasonable job of letting me know when there is a real problem with something, without me having to scour logs and sort through tons of irrelevant notifications?