Analyzing the errorlog

TiborKaraszi — Thu, 05 Jul 2012 11:53:00 GMT

How often do you do this? Look over each message (type) in the errorlog file and determine whether this is something you want to act on. Sure, some (but not all) of you have some monitoring solution in place, but are you 100% confident that it really will notify for all messages that you might find interesting? That there isn't even one little message hiding in there that you would find valuable knowing about? Or how about messages that you typically don't are about, but knowing that you have a high frequency can be valuable information?

So, this boils down to actually reading the errorlog file. Some of you probably already have scripts and tool that makes this easier than just reading every simple message from top to bottom. I wanted to share how I do it, and this is why I wrote my Analyze SQL Server logs article. Check it out. And, feedback is always welcome!

Management Pack for SQL Agent Alerts

TiborKaraszi — Mon, 01 Jun 2009 19:05:00 GMT

I have finished my article about suggested SQL Server Agent Alerts. Perhaps calling this a "Management Pack" is OTT, but hopefully it will be useful to some of you folks.

We are talking about having Agent sending email to us when SQL Server writes messages to EventLog. The functionality has been in the product since version 6.0, but I have always lacked some good "default setting". I'm talking about some easy way to tell Agent to notify me for messages which I typically want to be notified for. (Many of you are already using various Management software that has this functionality, so this won't be for you :-) ).

I very much welcome feedback, you find all information in the article:

http://www.karaszi.com/SQLServer/util_agent_alerts.asp

PS: I've blogged about related topics here: http://sqlblog.com/blogs/tibor_karaszi/archive/2009/02/23/where-s-that-sys-messages-management-pack.aspx, and here: http://sqlblog.com/blogs/tibor_karaszi/archive/2009/05/14/sp-altermessage-is-back-in-business.aspx.

Search results matching tags 'Tools', 'SQL Server Agent', and 'Troubleshooting'

Analyzing the errorlog

Management Pack for SQL Agent Alerts