Hi

Can you explain me how to configure sql 2000 enterprise
cluster for active active with one single data base .

Our main aim for sql cluster is to share the Load
for exisisting running database .
if it is not possible then suggest any other way for load
balancing of single sql data base .


HEMANT

The Microsoft cluster server (aka server clustering) is not created for
dynamic load balancing. If you only have a single database that allows both
reads and writes (i.e. not read only), you can't have it in a
'active/active' configuration in that both nodes are able to access it. A
database can only be in a single SQL2000 instance, it cannot be shared
between two or more instances, regardless whether the instances are
clustered or not. You can have an active/active cluster (with an instance
running on each node), but the database is controlled by only one instance
and runs on only one node at a time.

If you have a true performance load issue (after all the tuning), the
simplest way is to scale up, i.e. to get a bigger box. If your database fits
certain characteristics, you may be able to apply features such as
distributed partitioned views (DPV). Read the BOL on the DPV topic. Even if
you think you can take advantage of DPV, you should be aware that it's not
as easy to manage from an opertions perspective.

--
Linchi Shea
linchi_shea (AT) NOSPAMml (DOT) com


"Hemant Dhamane" <hemantd (AT) alkem (DOT) com> wrote

For what you are looking for, you should look into partitioning database
horizontally. It will be a architectural change and require rewriting of
signifiicant amount of code. Look in BOL under topic: Federated Database
Servers.


"Hemant Dhamane" <hemantd (AT) alkem (DOT) com> wrote

Another type of scale-out, which is simpler to manage, is
to see whether you have any reporting type of processing
that you can offload to a differen server, using for
instance replication.

Linchi