Forum Discussion

Tim_a_willis_92's avatar
Tim_a_willis_92
Icon for Nimbostratus rankNimbostratus
Sep 12, 2013

Load balancing read only SQL 2008R2 servers

We have everything setup in the LTM and everything is working right. Traffic is getting balanced equally between our MS SQL server (read only). But the issue we are seeing happens when a server goe...
design
sql server
Tim_a_willis_92's avatar
Tim_a_willis_92
Icon for Nimbostratus rankNimbostratus

The models used in this instance is the BIG-IP Virtual Edition, there are 4 of them in active/active/active/standby

 

Here is screen shot of the dashboard from the LTM hosting the SQL:

 

DashBoard

 

And thank you for your help with this!

 

What_Lies_Bene1's avatar
What_Lies_Bene1
Icon for Cirrostratus rankCirrostratus
Sep 13, 2013
You're welcome and thanks for the picture. I don't see why sending the return traffic back would be an issue performance wise, things look pretty low and as it's a performance L4 VS it's going to add very little overhead (and very little extra latency). Of course, testing is always advised.