Forum Discussion

tobin_dax_93013's avatar
tobin_dax_93013
Icon for Nimbostratus rankNimbostratus
Jan 11, 2010

Load Balancing SQL Servers

Hi All     I am new to F5 Systems and so apologise i am asking an obvisouly stupid question     I am attempting to load balanced 2 sql 2005 servers, DBA's have configured replica...
microsoft
partner
hoolio's avatar
hoolio
Icon for Cirrostratus rankCirrostratus
Jan 13, 2010
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