Load Balancing SQL Servers

Hi Tobin,

 

 

Is the connection making it to the pool members and back? If not, do you have the default gateway on the SQL servers set to the LTM self IP on their VLAN? If setting the default gateway to LTM isn't an option, you could try enabling SNAT. It would simplify things if you tested with all but one pool member disabled. That would rule out any persistence issues.

 

 

If you're not doing any inspection of the data, you could use a Perf Layer4 VIP with a FastL4 profile for faster handling of the connections through LTM.

 

 

If these options still don't work for you, can you post an anonymized copy of your VIP and pool config using 'b virtual VIP_NAME list' and 'b pool POOL_NAME list'? Please also include a description of what you're seeing in the tcpdump on the client and server side.

 

 

Thanks,

 

Aaron