Machine Unreachable alert too noisy + Feature request

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Machine Unreachable alert too noisy + Feature request

Postby jeffgonnering » Fri Oct 25, 2013 7:04 pm

for whatever reason, there is a server that is monitored by SQL Monitor that causes a Machine Unreachable alert quite frequently. For example:

Machine unreachable from: 25 Oct 2013 12:38:34 PM
Machine became reachable again at: 25 Oct 2013 12:38:36 PM

I would like to customize the alert, but the only options are to set as high, medium, or low which doesn't solve my too many false alarm emails issue. I don't want to disable the email because then I might miss an actual server down event or would have to actively monitor the alert. FEATURE REQUEST: It would be great if we could also add some sort of duration before sending an email. Like if the machine does not respond to a ping request for n consecutive seconds, then send an email.
Thanks.
jeffgonnering
 
Posts: 19
Joined: Mon Jan 03, 2011 11:35 pm
Location: Neenah, WI, USA

Postby RichyD » Mon Oct 28, 2013 5:15 pm

Out of interest, is the problem server a Win 2008 R2 box? I'm currently investigating various Machine Unreachable/Monitoring errors, and have found a rough correlation with Out of Memory exceptions in the Base Monitor log. These exceptions may be thrown by a misbehaving WMI provider service on the monitored box, in which a memory leak causes the service to increase in memory usage until it reaches a 512MB cap. The service will eventually recycle, but will effectively disable remote monitoring until it does.

I'm not saying that this is definitely my problem, or yours, but it is a potential line to check, particularly if (as in my case) you have multiple monitoring systems which both use WMI.

For ref: http://support.microsoft.com/kb/981314
RichyD
 
Posts: 7
Joined: Fri Oct 18, 2013 4:00 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest