Detecting recovery from Computer unreachable event?

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Detecting recovery from Computer unreachable event?

Postby mksql » Fri Apr 02, 2010 7:28 pm

If due to a transient network issue, SQL Response 1.3 alerts on a Computer unreachable event, is there a way via SQL Response I can detect a recovery from the condition?

I can of course logon to a system an ping/login to the SQL Server, but if I am remote, I would like to know if the situation continues.

Will the alert repeat?
mksql
 
Posts: 6
Joined: Fri Mar 05, 2010 10:35 pm

Postby mksql » Fri Apr 02, 2010 8:21 pm

SQL Response has recorded two more of these conditions, but I have received only one e-mail alerts.

It would be a useful configuration option for certain alerts to set the e-mail frequency. In the case of something as significant as "Computer unreachable", I would like to be notified on a regular frequency.
mksql
 
Posts: 6
Joined: Fri Mar 05, 2010 10:35 pm

Postby peter.peart » Tue Apr 06, 2010 2:27 pm

Hi there,

SQL Response will only e-mail you on the first occurence of the alert until the alert is cleared. The reasoning behind this is that if you had a CPU that was spiking, you could potentially end up with 400 e-mails in you inbox before you clear the alert.

Greater customizaion of e-mail behaviour is something that is scheduled for evrsion 2 of the tool though, as various people have reported that they would like the more control over this.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests