Setting up SQL Server in a Load balanced Active-Active configuration

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Spears - 26 Jul 2006 15:56 GMT

Hi
Can anyone point me to some documents details how to set up SQL Server in a
Load balanced Active-Active configuration??

We are using SQL Server 2000 (Enterprise), with Windows 2000 Advanced
Server. I don't think this is possible with Standard (??)

Thanks

Reply to this Message

Kalyan Yella - 26 Jul 2006 16:42 GMT

Load balancing is not available for SQL server cluster. And yes, you need
SQL Server 2000 Enterprise for clustering.

> Hi
> Can anyone point me to some documents details how to set up SQL Server in
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Arnie Rowland - 26 Jul 2006 17:13 GMT

In the 'normal' context of SQL Server, load balancing has no meaning.

If you are setting up an Active/Active cluster, each cluster instance will
have different resources (i.e., databases).

I suppose that you could use transactional replication to have to 'almost'
identical server/databases -but then how to direct clients since they would
have to request one instance or the other.

Nope, just doesn't make sense.

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

> Hi
> Can anyone point me to some documents details how to set up SQL Server in
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

10001110101 - 26 Jul 2006 20:18 GMT

There is, however a 3rd party tool that will allow you to do this:
http://www.resonate.com/prod_db_disp.html

Reply to this Message

Arnie Rowland - 26 Jul 2006 20:31 GMT

Resonate's product 'sounds' interesting. But the OP was about setting up
load balancing with a SQL Server Active/Active cluster. Resonate's product
does not do that.

And even with Resonate's product, there still is the issue of keeping the
databases synchronized. It has specialized uses, but clearly not for high
performance/highly reliable situations.

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

> There is, however a 3rd party tool that will allow you to do this:
> http://www.resonate.com/prod_db_disp.html

Reply to this Message

10001110101 - 26 Jul 2006 20:52 GMT

It was "documentation" that was relevant to the OP's question. I did
not get the impression that the original poster wanted opinion on what
was most appropriate for his/her implementation, but rather directional
documentation/ideas that could be perused to make an educated decision
regarding the deployment --and that is what I contributed. Offering
the details of what MSSQL can and cannot do is relevant, but more
importantly adding suggestions for alternatives could help engineer an
appropriate solution. Engineering the best solution is not always
black and white.

> Resonate's product 'sounds' interesting. But the OP was about setting up
> load balancing with a SQL Server Active/Active cluster. Resonate's product
[quoted text clipped - 14 lines]
> > There is, however a 3rd party tool that will allow you to do this:
> > http://www.resonate.com/prod_db_disp.html

Reply to this Message