I'm planning on building a SQL 2000 cluster, on 3-nodes
using W2K3, with 10 instances. All nodes will be active.
Each node will have 16GB RAM and 4 CPU's, connected to a
SAN.

Q1, is it true I can only build a max 4-node sql cluster
on W2K3 EE.
Q2, Does anyone have any documents on how to build a 3-
node cluster with 10 instances?
Q3, once the instances are built, can I add more instances
in the future? and how ?

I have built 2-node Exchange and SQL clusters
Active/Active in the past but not 3-node clusters.

Comments Inline

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

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

"Harbhajan" <anonymous (AT) discussions (DOT) microsoft.com> wrote


multi-instance system. Make sure and read:

PRB: Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default...&Product=sql2k

You will have to apply SP3a to each instance once you have installed the
instance.

Failover Cluster'. The short version is you install the first instance
(default or named) and get it up to date. You keep adding instances by
rerunning the install app and specifying new disks, IP address(es) and a new
network name. Each instance appears as a new virtual server on the network.

better. It is more an adjustment of thinking than anything else.

Good Luck.

Look at
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/default...&Product=sql2k

And see the "Managing AWE Memory" topic and the "Running Multiple Instances
and Using Failover Clustering" topic in SQL Server 2000 Books Online. If I
try and recap it here, I will likely miss something.


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

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

"Harbhajan Biran" <HarbhajanBiran (AT) discussions (DOT) microsoft.com> wrote in
message news:1740CB6D-BB2D-4DFC-9D8C-F13638CE3301 (AT) microsoft (DOT) com...

Do you have any update or advice on how you configured the 16GB memory
on your nodes? I am looking to go to 16GB memory on W2K3, SQL 2K
Enterprise (non cluster), and I am looking for others who have done
this. Lots of conflicting documentation out there about whether this is
stable & a good idea or not.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I have 32GB of RAM per box and I have had no issues due to memory size. At
16GB, do not use the /3GB switch in the boot.ini. Do use /PAE. Enable AWE
in SQL and set MAX MEMORY to the appropriate value. With a single instance,
I would go for 13 to 14 GB. With multiple instances, make sure you don't
overcommit memory should the instances fail over and all 'stack' on the same
node at the same time.

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

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

"DBEngineer" <dbengineer (AT) hotmail (DOT) com> wrote