Please advise cluster configuration

We have datawarehouse servwer with Active/Active cluster.
One node has 8GB Ram and another node has 12GB.
Right now I have configured for both the nodes the Max.Sql Server Memory to
be 8GB.
Both the nodes are running with windows 2003 SP1and SQL Server 2000 SP4 with
the 8 CPU.
Please advise the best configuration for this.
Thanks.
Best practice is that you keep the Hardware configuration of all your
cluster nodes the same.
Assuming that you already have the /PAE switch in your boot.ini file, I
would recommend that you add 4GB ram to the node with only 8GB ram.
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23UPSxwbNHHA.4152@.TK2MSFTNGP06.phx.gbl...
> We have datawarehouse servwer with Active/Active cluster.
> One node has 8GB Ram and another node has 12GB.
> Right now I have configured for both the nodes the Max.Sql Server Memory
to
> be 8GB.
> Both the nodes are running with windows 2003 SP1and SQL Server 2000 SP4
with
> the 8 CPU.
> Please advise the best configuration for this.
> Thanks.
>
|||Here, here to Edwin's recommendations.
Moreover, you did not say if this installation was x86 or IA-64.
If the former, you will need to set AWE enabled for the BPool to be able to
address more than 4 GB and you will want to limit each node to only 1/2 (or
slightly less) than available memory.
If the latter, and you are not running with Lock Pages in Memory, then you
could specify the full memory amount on each node, but you might want to
also specify a minimum memory amount as well. The Itanium build is more
aggressive about acquiring the minimum memory setting and will cause the
other instance to give up excess memory more readily.
The reason is that in a multi-instanced configuration, there will be times
when you will need or have to have multiple instances running on a single
node, and you will need available resources for each.
Sincerely,
Anthony Thomas

"Edwin vMierlo" <EdwinvMierlo@.discussions.microsoft.com> wrote in message
news:eyyfUfiNHHA.4720@.TK2MSFTNGP03.phx.gbl...
> Best practice is that you keep the Hardware configuration of all your
> cluster nodes the same.
> Assuming that you already have the /PAE switch in your boot.ini file, I
> would recommend that you add 4GB ram to the node with only 8GB ram.
>
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23UPSxwbNHHA.4152@.TK2MSFTNGP06.phx.gbl...
> to
> with
>
sql