SQL Server 2000 32 Bit on 64 Bit System

[VogonPoet]

We are trying to run SQL Server 2000 Enterprise Edition 32 bit on Windows Server 2003 64 bit running on Opteron 64 bit processors. SQL is only using a little under 4GB of RAM (we have 32) and I cannot find out how to use the balance of the RAM. I've already tried using sp_configure and 'awe enabled'. Can anyone point me in the right direction?

Thank you

 

[Jamfool]

http://www.sql-server-performance.com/awe_memory.asp

Well take a look at this.

 

[chiph]

We are trying to run SQL Server 2000 Enterprise Edition 32 bit

Here's a hint:
2^32 is 4,294,967,296, or 4gb

Your 32-bit database can only address 32-bits worth of memory, so it doesn't matter how much you have installed in the hardware, that's all it will see.

If you want to use all that memory, you'll need a 64-bit version of your database server. AFAIK, MS has not shipped one yet.

Chip H.


____________________________________________________________________
Donate to Katrina relief:

http://s1.amazon.com/paypage/PELYGQVJ8Q7IB/103-6821258-5919825

If you want to get the best response to a question, please read FAQ222-2244 first

 

[VogonPoet]

I did some more digging and it looks like I justed needed to set the PAE switch in boot.ini (just like with a 32 bit system. SQL is now seeing the memory.

 

[diesirae]

If you install Windows 2000 Advanced Server, you can use more than 4Gb with Ms SQL Server 2000.
There are a few parameters to config and then the SQL engine will use almost all of the ram.