MS SQL Server - Memory > 4GB on Cluster

Author

Memory > 4GB on Cluster

R Stovall

2006-04-08, 3:23 am

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

R Stovall

2006-04-08, 3:23 am

Should 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

Andrew J. Kelly

2006-04-08, 9:23 am

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

Sponsored Links