Memory > 4GB on Cluster

Hello. This topic has been beaten to death, so I apologize for asking the
question again. I just can't seem to get a handle on what I should do.
A client of mine has a 2 node SQL 2000 A/P failover cluster with Server 2003
Enterprise SP1 on each node and SQL 2000 Enterprise. They have been running
2GB of RAM for a couple of years, but we've decided to max the RAM to the
limit the hardware is capable of, which in this case is 6GB per node.
My understanding of what I need to do is this:
in boot.ini set /3GB and /PAE
in SQL enable AWE and set 'max server memory' to some appropriate value.
(In this case I think 5GB is a good place to start)
Am I forgetting anything? Misunderstanding anything?
Thanks,
RSShould have mentioned that SQL 2000 is SP4 with the kb899761 hotfix installed.
RS
"R Stovall" wrote:
> Hello. This topic has been beaten to death, so I apologize for asking the
> question again. I just can't seem to get a handle on what I should do.
> A client of mine has a 2 node SQL 2000 A/P failover cluster with Server 2003
> Enterprise SP1 on each node and SQL 2000 Enterprise. They have been running
> 2GB of RAM for a couple of years, but we've decided to max the RAM to the
> limit the hardware is capable of, which in this case is 6GB per node.
> My understanding of what I need to do is this:
> in boot.ini set /3GB and /PAE
> in SQL enable AWE and set 'max server memory' to some appropriate value.
> (In this case I think 5GB is a good place to start)
> Am I forgetting anything? Misunderstanding anything?
> Thanks,
> RS|||Yes that is correct. Just set the Max Memory to 5GB before you set AWE on
and you should be all set.
--
Andrew J. Kelly SQL MVP
"R Stovall" <richard-at-@.shuffle-daht-.com> wrote in message
news:003BEE08-0F80-466A-BAFA-031FF4A0C19C@.microsoft.com...
> Hello. This topic has been beaten to death, so I apologize for asking the
> question again. I just can't seem to get a handle on what I should do.
> A client of mine has a 2 node SQL 2000 A/P failover cluster with Server
> 2003
> Enterprise SP1 on each node and SQL 2000 Enterprise. They have been
> running
> 2GB of RAM for a couple of years, but we've decided to max the RAM to the
> limit the hardware is capable of, which in this case is 6GB per node.
> My understanding of what I need to do is this:
> in boot.ini set /3GB and /PAE
> in SQL enable AWE and set 'max server memory' to some appropriate value.
> (In this case I think 5GB is a good place to start)
> Am I forgetting anything? Misunderstanding anything?
> Thanks,
> RS|||Thank you for confirming this. I appreciate the help very much.
RS
"Andrew J. Kelly" wrote:
> Yes that is correct. Just set the Max Memory to 5GB before you set AWE on
> and you should be all set.
> --
> Andrew J. Kelly SQL MVP