Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitoring Windows Event Logs Expand / Collapse
What tool do you use to monitor the Windows Event Logs on a machine hosting SQL Server?
Poll ResultsVotes
Windows Event Viewer
 
38.1%
8
LogParser
 
9.52%
2
PowerShell Get-WmiObject
0%
0
PowerShell Get-EventLog
 
4.76%
1
VBScript + WMI
0%
0
I do not review them regularly
 
23.81%
5
Other (please add a comment to the thread)
 
23.81%
5
Member Votes: 18, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Tuesday, January 10, 2012 2:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 7,070, Visits: 12,523
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
Posted Wednesday, January 11, 2012 2:56 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 7,070, Visits: 12,523
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
Posted Wednesday, January 11, 2012 3:04 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:04 PM
Points: 198, Visits: 1,116
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
Posted Wednesday, January 11, 2012 3:48 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:58 AM
Points: 5,845, Visits: 12,572
SCOM

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

Post #1234437
Posted Thursday, January 12, 2012 1:54 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 03, 2013 9:24 AM
Points: 1,511, Visits: 250
SCOM


Post #1234568
Posted Thursday, January 12, 2012 9:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:27 PM
Points: 217, Visits: 1,061
We've got a powershell script to collect this info.
Post #1234987
Posted Wednesday, October 31, 2012 5:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, October 31, 2012 10:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:56 PM
Points: 237, Visits: 761
Nagios - SCOM as secondary. We had issues with SCOM, e.g. slowness, missing things and downtime.
Post #1379422
Posted Wednesday, October 31, 2012 10:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:56 PM
Points: 237, Visits: 761
Sorry, that was my old role.
In my new role we use PRTG.
Post #1379425
Posted Wednesday, October 31, 2012 10:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 7,070, Visits: 12,523
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 »

Add to briefcase

Permissions Expand / Collapse