mirroring--changing failover sensitivity

• jay-h

  SSCoach

  Points: 18816

  More actions

  April 14, 2010 at 1:35 pm

  #140378

  We have several databases on mirroring with automatic failover. We have had several occasions where failover has occurred even though the databases were all up and running... this plays havoc with some apps.

  I see in the logs that failover seems to occur when a server does not get a response within 10 seconds. Is there a way to change that?

  ...

  -- FORTRAN manual for Xerox Computers --

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  April 14, 2010 at 3:44 pm

  #1151791

  To change the time-out value (high-safety mode only)

  Use the ALTER DATABASE <database> SET PARTNER TIMEOUT <integer> statement.

  To view the current time-out value

  Query mirroring_connection_timeout in sys.database_mirroring.

  ---------------------------------------------------------------------