Monitoring Windows Event Logs

  • I am curious about which tools people are using to monitor Windows Event Logs on servers hosting SQL Server.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Wow, 20 thread views and not one poll reply or comment? Is everyone ignoring the Windows Event Log entries on their SQL Servers?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • I used a VBScript and WMI in my last job. Responsibiities are more segregated where I am now and that would be an IT function. They use SCOM, but I'm not sure how much event log monitoring it has available.

  • SCOM

    ---------------------------------------------------------------------

  • SCOM

  • We've got a powershell script to collect this info.

  • Lepide Event Log Manager am currently using.... the tool provides a simplified platform to centrally archive, consolidate and monitor network-wide Windows and W3C event logs

  • Nagios - SCOM as secondary. We had issues with SCOM, e.g. slowness, missing things and downtime.

  • Sorry, that was my old role.

    In my new role we use PRTG.

  • Thanks for all the replies!

    I appreciate the insight into what others are doing. I think I would prefer to use SCOM but it's not available in the current shop unfortunately. I settled on LogParser.exe which can pull Event Logs directly into a SQL Server database table. I do the necessary inspection on the table and email a report of interesting events from a stored proc which I call after calling LogParser.exe. All of the steps are tied together by a PowerShell script which is scheduled to run nightly. It's a homegrown solution to be sure, but I built the PowerShell script to read a set of servers from a text file so it scales out nicely for this environment where there are lots of servers and some are coming online others are going offline on a regular basis.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 10 posts - 1 through 9 (of 9 total)

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