Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 17, 2014 8:30 AM
Points: 13, Visits: 590
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)??

Thanks!
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: 2 days ago @ 2:56 PM
Points: 835, Visits: 1,191
You can leave it as is but increase PARTNER TIMEOUT.
Post #1459434
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse