Number of Nodes and Instance on Windows 2003 Cluster

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@.visionitgroup.com> wrote in message
news:B59BD2B2-E7DF-4642-9613-78722FA27374@.microsoft.com...
> How many Ressource group or Virtual SQL server may I run on on Windows
> 2003
> cluster node ?
>
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.

> How many nodes can I have for an SQL Cluster architecture ?
Windows 2000 = 2
Windows 2003 32 bit = 4
Windows 2003 64 bit = 8

>Apparently Four
> ?
With the 32-bit OS, yes.
May someone confirm this number ?
I just did

>and is it four active instances or 3
> active/ 1 passive ?
>
You can do all 4 Active, though I would never do this.

> What happend if I have four SQL resource group with a eight nodes Windows
> 2003 cluter ?
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@.die.spam.die.nw-america.com> wrote in
message news:%23ojM6JOkEHA.644@.tk2msftngp13.phx.gbl...
> answers inline below...
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> "Jean-Michel Remiche" <jmr@.visionitgroup.com> wrote in message
> news:B59BD2B2-E7DF-4642-9613-78722FA27374@.microsoft.com...
> 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...microsoft.com
:80/support/kb/articles/Q185/2/12.ASP&NoWebContent=1)[vbcol=seagreen]
> 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.
Windows
> 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
>
sql