Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Mirroring Alert Expand / Collapse
Posted Thursday, May 23, 2013 2:29 PM


Group: General Forum Members
Last Login: Wednesday, October 19, 2016 3:05 PM
Points: 15, Visits: 829
Quick question...

I have an alert set up to email me whenever one of my mirrors move into state 6 ("connection with mirror lost"). Most times it loses the connection for a very brief time and doesn't reach the threshold for a failover (a network issue). This of course triggers an alert, when really I don't want to be alerted until the connection's been lost for 5 seconds.

Will the "Delay Between Responses" option on the alert properties dialog box (set to 5 seconds of course) get me where I want to be, or will I have to employ some more complicated solution? Or, should I simply not monitor for state 6 and only monitor for when failovers have occurred (states 7 & 8)??

Post #1456217
Posted Monday, June 3, 2013 12:56 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 4, 2016 12:22 PM
Points: 863, Visits: 1,314
You can leave it as is but increase PARTNER TIMEOUT.
Post #1459434
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse