SQL and Event logs Monitoring Scripts

  • I would like to monitor SQL and Event logs thru Scripting for all the SQL Servers in our environment, Does any one know of any scripts?

    Please respond.

    Thanks and Regards

  • While I don't think this is in the proper forum.....at my last job, we used a tool called ELM (event log monitoring) which would monitor for all types of messages sent to the event log, for all our production servers. Filters could be placed on the "what" and options to be taken (email, page, etc.) based on the rules we created. It took a little while to get things setup the way we liked but it was a great tool (and it may have been a little expnsive!). There are probably other 3rd party tools as well. As far as scripting, it depends on what your want to find. I have a script that I run daily to find any failed jobs that may have occurred. Beats having to sift through 30 or 40 emails to find the ones I should be concerned with. I am in the process of changing things to only notifying on exceptions as opposed to all job completions - one of the drawbacks to being the new man on the block and wanting things done my way - but I'll get there!

    -- You can't be late until you show up.

  • You might try here as well:http://www.sqlservercentral.com/articles/Monitoring/61373/

    Event logs are usually done with some third party product outside of SQL. I've used What's Up before to do this.

    Moved to admin

  • Steve - funny that you should mention What's Up. I just downloaded What's Up Gold two days ago. Didn't want to suggest it (yet) as I have just started to work with it. Seems fairly simple to work with and relatively inexpensive - IMO

    -- You can't be late until you show up.

  • i set up a system using a free MS tool called logparser

    i use it to dump logs into a db and then have SQL code along with SQL 2005 reports set up for viewing

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply