|Subject:||Re: Load balance|
|Posted by:||Michael Hotek (mhot…@mssqlserver.com)|
|Date:||Mon, 28 Aug 2006|
To load balance the processing, you would want to look at Service Broker
since you can create a single queue and then have multiple brokers handle
the processing requests.
However, you need to take a look into Database Mirroring if you want to be
redundant as well as fault tolerant since Database Mirroring will
transparently fail over the broker queues.
MHS Enterprises, Inc
"Casper Hornstrup" <…@eudicon.com> wrote in message
> 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?
Load balance posted by Casper Hornstrup on Sun, 27 Aug 2006