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: Yesterday @ 9:57 AM
Points: 7,080, Visits: 12,571
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
Post #1233561
Posted Wednesday, January 11, 2012 2:56 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 7,080, Visits: 12,571
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
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: Tuesday, July 22, 2014 9:45 AM
Points: 198, Visits: 1,126
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: Yesterday @ 1:50 PM
Points: 5,974, Visits: 12,877
SCOM

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

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

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 1:52 PM
Points: 1,511, Visits: 254
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: Yesterday @ 8:00 AM
Points: 234, Visits: 1,083
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: Yesterday @ 3:09 PM
Points: 253, Visits: 797
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: Yesterday @ 3:09 PM
Points: 253, Visits: 797
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: Yesterday @ 9:57 AM
Points: 7,080, Visits: 12,571
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
Post #1379445
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse