have a server running windows 2003 enterprise edition 64-bit and this server has 18GB of Ram.
I am running Sql Server 2000 enterprise edition (32-bit) on it. Sql server is only using 4GB of RAM.
I see some articles online claiming you need to configure SQLServer to use AWE to access more than 4 GB. However this article states that AWE is not required and cannot be configured on 64-bit operating systems.
I tried setting the Min Memory for the server, however I get the following message in the sql error log: Warning: unable to allocate 'min server memory' of 14748MB.
Best Answer
You'll need to be on SQL Server 2000 SP4. Though Windows 2003 Enterprise Edition (64-bit) doesn't support PAE, it does support the APIs 32-bit apps will use to make the calls. So you can enable SQL Server to use AWE memory and adjust the memory accordingly. More info can be found in this thread.