Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000

Both machine has 4 GB o Physical Memory (RAM), but I want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.

So, That is possible?

1) Is possible to have differentes memory configuration in a cluster?
2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?


Thanks a lot!!


AA

I forgot to mention that both machine are with 32 bits processors

Thanks again

AA

"AA" <aa (AT) personal (DOT) net.py> wrote

1. Yes, it is possible. Not sure why you'd want to do it though.
2. Yes, it is supported as long as you enable AWE.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

1. ) because an error in the requirement the cluster come with 4 GB Memory
each, but I think that the Active Server must be more powerful

In the current environment we have installed SQL 2000 in a single machine
dual processor and is UP without restart (the OS and the DB) for more that 6
months, without any kind of problems. In two years we NEVER have any
problems with our SQL 2000 database. I am very happy

So, I want to use the Pasive machine just for emergencies (when the Active
Failure) and increment the Active server power.

Is that ok?

Thanks Michael

AA

"Michael Hotek" <mhotek (AT) nomail (DOT) com> wrote

Yes, you can do that. You just need to recognize that if you ever have to
fail over, you can have some performance issues.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com