July 3, 2003 at 3:18 pm
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
July 3, 2003 at 4:57 pm
it can take as little as a few seconds and as much as minutes normally I see about a 30 second lag for failover between nodes and sql starting up. this is on two 6 way boxes with 8 gig of ram.
wes
July 10, 2003 at 5:33 am
yes, we see seconds to a minute.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply