Load balancing MSSQL

NetScaler is the only certified load balancer that can load balance MySQL and MSSQL services. It can be quite complex, and there are many requirements that need to be in place in order to set up a proper load-balanced SQL server.

Let's go through how to set up a load-balanced Microsoft SQL Server running on 2008 R2. It is important to remember that using load balancing between the end clients and SQL Server requires that the databases on the SQL server are synchronized. This is to ensure that the content that the user is requesting is available on all the backend servers. Microsoft SQL Server supports different types of availability solutions, such as replication. You can read more about it at http://technet.microsoft.com/en-us/library/ms152565(v=sql.105).aspx ...

Get Implementing NetScaler VPX™ - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.