June 27, 2003 at 3:09 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
June 27, 2003 at 4:23 pm
The second node will function just the same as SQL Server starting up, meaning database recovery, etc. In our own testing, we've not seen times > 30 seconds, which is within the default connection timeout. Best way to find out for your environment is to perform the failover and check the time it takes. This wouldn't give you an exact time, since the first node is going to let go of resources cleanly, but it'll give you a ballpark.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply