Load balance

Giganews Newsgroups
Subject: Load balance
Posted by:  Casper Hornstrup (…@eudicon.com)
Date: Sun, 27 Aug 2006


My application is based on ASP.NET 2.0 and SQL Server 2005. Most of my
data-processing happen on the SQL Server (in two stored procedures written
in C#) - the webserver don't do much in this setup. I'm investigating ways
to have load balancing of the data-processing accross multiple (physical)
SQL Servers in addition to having failover support in case one SQL Server
does fail. Do I need to design my application specifically to support
distributed processing or can SQL Server 2005 do this transparently? What
options do I have?