Competition: What’s your favorite Redgate tool? Enter now.

Detecting recovery from Computer unreachable event?

mksqlmksql Posts: 10
edited April 6, 2010 9:27AM in SQL Monitor Previous Versions
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?

Comments

  • 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.
  • 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
Sign In or Register to comment.