load balancing cluster

need the concpet of load balancing cluster ?

can any one help me out with any link...?"Nit" <chat2martin@.gmail.comwrote in message
news:160cafd7-3fd1-4a2b-9eab-38d66213654f@.b40g2000prf.googlegroups.com...

Quote:

Originally Posted by

>
>
need the concpet of load balancing cluster ?
>
can any one help me out with any link...?

For SQL Server not relaly because that exact model doesn't exist. In MS SQL
Server, a cluster is a DR/failover mechanism. I.e. the DB is live on only
ONE node of the cluster at a time.

A common solution though is to use things like replication or even
log-shipping to create read-only copies of the DB and point some of your
load there.

Quote:

Originally Posted by

>
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html