How many instances in one luster box

hi,
How many instances could have in an active/passive and an active/active
cluster box ?
Thanks,
It states in the SQL2005 cluster active/passive (SQL2005foc.pdf) install
that you can have over 21 but the requirements for each instance is a
dedicated data drive if you intend for the failover to work per
instance, Network Name and IP per instance (this could be a "maybe"
depending on port/connections requirements of your apps and if they are
cluster aware). How many drive letters are availiable if you have to
assign one per instance . Resources like Memory and CPU may be
difficult to assign. Enjoy!
Mary
info@.sqltime.com
*** Sent via Developersdex http://www.codecomments.com ***
|||The names come from when we were dealing primarily with 2-node clusters.
Active/passive = 1 instance of SQL Server running (meaning only one of the
two servers was being used). Active/Active = 2 instances of SQL Server running
(typically one instance per physical server).
As far as how many instances you can run on one cluster, I believe it depends
on the # of instances allowed per version of SQL Server, cluster or not.
Those numbers are:
SQL Server 2000: 16
SQL Server 2005: 16 (not Enterprise Edition), 50 (Enterprise Edition)
The limit for SQL Server 2005 Enterprise Edition could never be reached,
though, because you would exhaust the # of drive letters (26 max). The example
given in the SQL Server 2005 Books Online documentation has 23 separate instances...
which I suppose is possible if the first 3 drive letters are assigned to
the system drive, the quorum drive, and the DTC drive.
K. Brian Kelley, brian underscore kelley at sqlpass dot org
http://www.truthsolutions.com/

> hi,
> How many instances could have in an active/passive and an
> active/active cluster box ?
> Thanks,
>
|||I've had 16 instances on serveral 4 node x64 clusters which is a fairly
reasonable practical limit because as has already been stated you will run
out of drive letters. In this scenario, we used mount points for each
instance for data/logs/tempdb/backups. It actually worked very well (takes a
while to install and service pack mind you!) after some initial sql setup
related issues with the consistency checker which were fixed by applying the
latest COM+ hotfix rollup.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O6DhThmaHHA.2448@.TK2MSFTNGP02.phx.gbl...
> hi,
> How many instances could have in an active/passive and an active/active
> cluster box ?
> Thanks,
>
|||Can you use Mount Points if one side of your cluster is a Virtual Server
(or VMware server)?
Thanks,
Mary
*** Sent via Developersdex http://www.codecomments.com ***
|||Not sure, I've never tried mixing a physical server with a VM in a cluster
(it would certainly be an unsupported configuration). I've actually found
Virtual Server to be more useful for testing than VMWare as we seem to see a
lot of delayed lost writes with VMWare shared disks (although this may be a
configuration issue). I find using VM's very useful for training and testing
our automated cluster installation.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Mary Myers Devlugt" <info@.sqltime.com> wrote in message
news:ejUs68zaHHA.4552@.TK2MSFTNGP05.phx.gbl...
> Can you use Mount Points if one side of your cluster is a Virtual Server
> (or VMware server)?
> Thanks,
> Mary
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||"Mary Myers Devlugt" <info@.sqltime.com> wrote in message
news:ejUs68zaHHA.4552@.TK2MSFTNGP05.phx.gbl...
> Can you use Mount Points if one side of your cluster is a Virtual Server
> (or VMware server)?
Yes you can.
However, such a configuration would not be supported. A non-supported
configuration sure doesn't meet the requirements of a highly available
environment, either.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp