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,

RS

Should have mentioned that SQL 2000 is SP4 with the kb899761 hotfix installe
d.

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 20
03
> Enterprise SP1 on each node and SQL 2000 Enterprise.  They have been runni
ng
> 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@microso
ft.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