Hello,
I would like to know your opinion about running 4-8 SQL 2K
instances on each node of a multi-node (2) cluster, with 8
production databases on each node (spread over the
instances).
Hardware: 2 Pentium 4 2.8 GHz dual processor systems with
2 Gb memory (can be upgraded with processor power and
memory).
Question 1) Possible or something to laugh about?
Question 2) If possible, do you know similar sites?
Thanks, Rinus.

8 Instances on a single server with only 2GB of ram sounds pretty thin.
Unless each instance is a very small database or not heavily used your
probably pushing the memory. What is the reason for wanting individual
instances vs just dbs?



--

Andrew J. Kelly
SQL Server MVP


[quoted text, click to view]

Hi -
To answer the question, YES - it is possible to run 16 instances
in a 2 node cluster.
2 GB of RAM sounds less but if you have plans to upgrade this, then it is
fine.
Just a word of caution while you plan for your installation:
You also need to plan running the instances with failover in the top of the
mind. Incase for some reason if node 2 fails, then potentially you may
have all 16 instances running on one node!!

Regards,
Chandra
--------------------
||Content-Class: urn:content-classes:message
||From: "Rinus Heer" <Rinus.Heer@Getronics.com>
||Sender: "Rinus Heer" <Rinus.Heer@Getronics.com>
||Subject: 8-16 instances on a SQL2K cluster advisable?
||Date: Mon, 2 Feb 2004 06:48:10 -0800
||Lines: 13
||Message-ID: <8ced01c3e99b$93eab0e0$a601280a@phx.gbl>
||MIME-Version: 1.0
||Content-Type: text/plain;
|| charset="iso-8859-1"
||Content-Transfer-Encoding: 7bit
||X-Newsreader: Microsoft CDO for Windows 2000
||X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
||Thread-Index: AcPpm5PqfNqy/CpeTEuGU4nXVpxdkQ==
||Newsgroups: microsoft.public.sqlserver.clustering
||Path: cpmsftngxa07.phx.gbl
||Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.clustering:12704
||NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
||X-Tomcat-NG: microsoft.public.sqlserver.clustering
||
||Hello,
||I would like to know your opinion about running 4-8 SQL 2K
||instances on each node of a multi-node (2) cluster, with 8
||production databases on each node (spread over the
||instances).
||Hardware: 2 Pentium 4 2.8 GHz dual processor systems with
||2 Gb memory (can be upgraded with processor power and
||memory).
||Question 1) Possible or something to laugh about?
||Question 2) If possible, do you know similar sites?
||Thanks, Rinus.
||
||
||