Clustered Data Server

• cbarus

  SSCommitted

  Points: 1741

  More actions

  June 27, 2003 at 8:49 am

  #159733

  Our dataserver is clustered (active-passive). I understand that if a failover were to occur, all the client connections will be diconnected and will have to re-connect to the database server.

  a. If a connection fails, how long should it be before the client should retry for a connection?

  b. When the failover occurs, will the instance on the second node have to recover all the databases just the way SQL Server does if the server crashes?

  c. What would be a typical, recommended time out period for the client applications?

  Thanks for all the help

• June 30, 2003 at 8:00 am

  This was removed by the editor as SPAM

• peterus

  SSC Veteran

  Points: 287

  More actions

  July 3, 2003 at 10:33 am

  #464108

  A. Depends on a number of factors, a safe bet is 5 minutes.

  B.Yes

  C.30 seconds max, depends on the speed of your app. Fast app=lower timeout value. Reports for example an run for minutes...