Monitoring Windows Event Logs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Monitoring Windows Event Logs

Monitoring Windows Event Logs

Rate Topic

Display Mode

Topic Options

What tool do you use to monitor the Windows Event Logs on a machine hosting SQL Server?

Poll Results

Votes

Windows Event Viewer

38.1%

LogParser

9.52%

PowerShell Get-WmiObject

PowerShell Get-EventLog

4.76%

VBScript + WMI

I do not review them regularly

23.81%

Other (please add a comment to the thread)

23.81%

Member Votes: 18, Anonymous Votes: 0. You don't have permission to vote within this poll.

Author

Message

opc.three

Posted Tuesday, January 10, 2012 2:44 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:41 PM
Points: 6,724, Visits: 11,769

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1233561

opc.three

Posted Wednesday, January 11, 2012 2:56 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:41 PM
Points: 6,724, Visits: 11,769

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1234406

Chuck Hottle

Posted Wednesday, January 11, 2012 3:04 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:35 PM
Points: 197, Visits: 1,068

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.

Post #1234415

george sibbald

Posted Wednesday, January 11, 2012 3:48 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:35 PM
Points: 5,269, Visits: 11,208

SCOM

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

Post #1234437

azdzn

Posted Thursday, January 12, 2012 1:54 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 12:46 PM
Points: 1,493, Visits: 239

SCOM

Post #1234568

vultar

Posted Thursday, January 12, 2012 9:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 189, Visits: 919

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

Post #1234987

peterdru401

Posted Wednesday, October 31, 2012 5:47 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 8:34 AM
Points: 23, Visits: 128

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

Post #1379262

arnipetursson

Posted Wednesday, October 31, 2012 10:27 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:27 PM
Points: 135, Visits: 417

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

Post #1379422

arnipetursson

Posted Wednesday, October 31, 2012 10:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 3:27 PM
Points: 135, Visits: 417

Sorry, that was my old role.
In my new role we use PRTG.

Post #1379425

opc.three

Posted Wednesday, October 31, 2012 10:58 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:41 PM
Points: 6,724, Visits: 11,769

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1379445

« Prev Topic | Next Topic »

Permissions