F5 to load balance MS Sql Servers

 

kbsartain

 

 

If you have .NET code, or any other code that can take advantage of connection pooling, then you may have issues during the transition. Connection pooling persists connections to the database from the client and re-uses them. Without pooling, each query opens a new connection. During a failover, the persisted connection to the DB will break, but you have to ensure that a "TCP FIN" is sent back to the client, or all subsequent queries to the pool will fail.

 

 

 

 

You can configure LTM to send a TCP reset if the selected pool member is marked down. This can be configure in the pool properties under 'Action on Service Down'.

 

 

 

atmfrank

 

Can I use a F5 LTM device to manage the front-end traffic for a set of regionally dispersed MSSQL 2005 servers ?

 

 

 

 

LTM can load balance hosts that are on a local subnet or on remote networks with a route.

 

 

Aaron