How many Ressource group or Virtual SQL server may I run on on Windows 2003
cluster node ?

How many nodes can I have for an SQL Cluster architecture ? Apparently Four
? May someone confirm this number ? and is it four active instances or 3
active/ 1 passive ?

What happend if I have four SQL resource group with a eight nodes Windows
2003 cluter ?

answers inline below...

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Jean-Michel Remiche" <jmr (AT) visionitgroup (DOT) com> wrote

SQL supports a 4 node cluster on a 32-bit OS. Each SQL supports 16
instances. Given that you have monster machines and an A/A/A/A cluster you
could have 64 databases in the cluster.

I am not aware of a limit to resource groups in clustering. Files shares
have been limited in the past
(http://support.microsoft.com/default...NoWebContent=1)
but I have not seen anything on Groups.

Windows 2000 = 2
Windows 2003 32 bit = 4
Windows 2003 64 bit = 8

With the 32-bit OS, yes.

May someone confirm this number ?

I just did

You can do all 4 Active, though I would never do this.

SQL will only install on any 4, though I have not tested this.

Source of information:
http://www.microsoft.com/usa/webcasts/ondemand/1751.asp

Under Windows 2003 and SQL 2000 here are the rules.
Each cluster can have 8 host nodes.
Each cluster can have 16 instances. (Note that this is a Cluster-wide limit,
not a host node limit.
Each SQL instance can be installed on up to 4 nodes. (8 for 64-bit, it is an
installer limitation)
Each SQL Resource group = 1 instance.
Each SQL instance = 1 Resource group.
You can have non-SQL resource groups in the cluster, but it is generally a
bad idea except for the MSDTC resource group.
Forget you ever heard of 'active/active' or 'active/passive' or any
variation of those. Those terms referred to some technical limitations of
SQL 7.0 clustering and have no real meaning for SQL 2000 clustering.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in
message news:%23ojM6JOkEHA.644 (AT) tk2msftngp13 (DOT) phx.gbl...
:80/support/kb/articles/Q185/2/12.ASP&NoWebContent=1)