Options
Detecting recovery from Computer unreachable event?
mksql
Posts: 10
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?
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?
Comments
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.
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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569