Clustering in Active/Active

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wicky - 27 Jul 2006 00:27 GMT

Dear all,

My client would like to set up a SQL Server with Active/Active Clustering
with SAN. Is it possible to do a loadbalancing of the database in SQL Cluster
environment? Such as, can I using same/difference instance to mount the same
database resources in the SAN disk?

Thanks

Reply to this Message

Geoff N. Hiten - 27 Jul 2006 01:09 GMT

In short, No.

SQL Server clustering is a failover technology, not a scale-out technology.
If you want more database processing power, purchase a larger server.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Dear all,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Denilson - 28 Jul 2006 21:57 GMT

I'm plan migrate a instance of SQL Server in 1server with 4 processors
to Cluster with 2 node and 2 processor for node.
There is any solution for load balancing in this case.

Denilson

> In short, No.
>
[quoted text clipped - 5 lines]
> Senior Database Administrator
> Microsoft SQL Server MVP

Reply to this Message

Linchi Shea - 29 Jul 2006 02:40 GMT

Assume that these are the same class of processors and your app absolutely
needs the processing power of the 4 processors, then you either (1) should
not migrate the app to the 2-proc per node cluster, or (2) add two more
processors to each node.

Linchi

> I'm plan migrate a instance of SQL Server in 1server with 4 processors
> to Cluster with 2 node and 2 processor for node.
[quoted text clipped - 11 lines]
> > Senior Database Administrator
> > Microsoft SQL Server MVP

Reply to this Message