Re: Load balance

Giganews Newsgroups
Subject: Re: Load balance
Posted by:  Michael Hotek (mhot…
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.

Mike Hotek
MHS Enterprises, Inc

"Casper Hornstrup" <…> wrote in message
> Hi.
> 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?
> Regards,
> Casper



In response to

Load balance posted by Casper Hornstrup on Sun, 27 Aug 2006