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)??