Dear, I am needing to grant tolerance to shortcomings to a Server
SQL. The consultation is the following one, in Windows 2003 can have up to 8
nodes
in a Cluster, in my Cluster at the moment have two instances of SQL, it is
to say, an active/active, according to the above-mentioned, I can add him a
third
node to the Cluster, but I don't have clear if I can install a third
instance
in that same cluster, a thing like activo/activo/activo, somebody has him
fact or is it theoretically and technically fáctible....??, according to my
theory,
it could be feasible, since to the moment to install the third instance
Virtual, he/she should only choose available two nodes of the three.....,
now
not you if this is feasible in he/she practices it.
Thank you for their attention.
Greetings.

Atte.,
Carlo Sorrel

Hi

Windows 2003 supports 8 node clusters.
SQL Server 2000 supports 4 node clusters, with up to 16 instances of SQL
Server per cluster.

Yes, adding a 3rd node, and running a 3rd instance is possible as is being
used by various customers of Microsoft.

Done think about active/passive active/active etc, think using the new
terminology of "instances".

The biggest thing you have to worry about in multiple instance clusters is
if all instances were to be failed over to 1 node, does the 1 node have
enough RAM to support them all? If you have 3 nodes, each node with 4 GB RAM
and you allocate 2GB per instance, and you failed all 3 instances over to 1
node, the 1 node would not be able to start the last instance as there is
2GB RAM too little.

If you had 2 nodes, in effect, you could run 8 instances on node 1 and 8
instances on node 2, or any combination, adding up to 16, assuming you have
enough resources.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Carlo Sorrel" <csorrel (AT) hotmail (DOT) com> wrote