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 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@.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

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

membership control, MSDE, SQLExpress

can I implement the membership control (provided by ASP.NET) on MSDE? my web hoster is not supporting SQL2005 that is why i am asking this. my web project is using ASP.NET 2.0, C#, SQLExpress2005. i am not sure if i migrate to MSDE it can implement the membership control. im sorry if i sound dumb. im really a newbie.

thanks.
Already answered here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=413760&SiteID=1

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de