I would like to receive an email every day from each of "my" SQL Servers, with information from the ErrorLog.

I would like an easy way to determine if there is any important new information, that I should not overlook.

So I've tried to categorise all the messages into "Database Backup", "Reboot", "Noise" etc. All un-categorised messages I list as "Unusual event".

I've been looking for some time for a list of messages that it is safe to ignore, but found none. So here is my list.

Am I pruning the list too hard?
Are there other messages that I should ignore?
Can you point me to other methods, that work better?

here is my code: github gist

  • Going through sys.messages would probably help you come up with a better list of what to include. – Erik Darling Oct 23 '18 at 13:58
  • @sp_BlitzErik; yes that is a good idea. Thank you. But how to categorise them? And there are 13255 in each language... – Henrik Staun Poulsen Oct 23 '18 at 14:12
  • "Critical" and "Not Critical" – Erik Darling Oct 23 '18 at 14:14
  • @sp_BlitzErik; and it is not all of them that can appear in the ErrorLog, as in "TOP is not allowed in an UPDATE or DELETE statement against a partitioned view.". But I could go by Severity – Henrik Staun Poulsen Oct 23 '18 at 14:19
  • 1
    I think you are in for some hard work here, Henrik. I use Agent alerts for the stuff I want to get emails from (I have a script for that on my web-site). And then I manually now and then go through the errolog to find "weird things", using another script on my we-site. – Tibor Karaszi Oct 24 '18 at 7:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.