How to load-balance SQL Server 2008 for high-usage ASP.NET applications?
If it’s high availability you need, then Windows/SQL Server Clustering or SQL Server Database Mirroring offer solutions. Clustering does require a lot of planning and familiarisation if you’ve never done it before, but it will be transparent to the application. Load balancing is possible with SQL Server, but it’s not for the faint hearted. It’s … Read more