Re: SQL 2005 Cluster Setup

Hi,

I am looking at the load balancing story (Oracle RAC has that). I need to
be clear on this issue as I am going against Oracle RAC on this
scale-out/scale-up story line. Thanks.

Regards,
Kueh.

"Jasper Smith" wrote:

No (to the load balancing bit). SQL Server supports the idea of shared
readonly databases (http://support.microsoft.com/?kbid=910378) however I'm
guessing you mean something more like what Oracle offer with RAC? You can of
course implement it yourself (possibly using peer to peer replication) but
clustering in SQL Server is purely for availability and not for load
balancing

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


"KA Kueh" <KAKueh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D3762172-8759-447F-9F70-A6F3DEA54099@xxxxxxxxxxxxxxxx
Dear all,

I would like to ask a seemly trivial question. Is it possible to setup an
Active/Active two node SQL cluster that has only one instance. I mean
that
the cluster would actually do load balancing when running.

Thank you.

Regards,
Kueh.



.