F5 to load balance MS Sql Servers

Thanks for your reply Ryan. We did consider the synchronization risk that goes with load balancing solution and as you said, we are not looking to use Big IP to load balance, instead it is to do switching between database servers the fastest possible way. For example, when the huge data load job on the data warehouse side is completed, users need to be switched to a different database server and vice versa. Using Microsoft Cluster Services, there is a downtime for the services to go down on one box and come up on the other, in short it can't do Active-Active cluster.

 

 

I hope I made sense with my description. Welcome any questions.

 

 

Appreciate your time.