Wind 2k3 Std 64 bit and SQL 2000 EE

New and stumbled into what is currently in place
We have a Windows 2003 Std. 64 bit box (up to 32 GB RAM) and has 8 GB of RAM.
AWE is enabled and is set to use 7 GB of memory but is only using 4 GB.
From what i have read to get it to use more than 4 GB of memory i need to add the PAE switch to the boot.ini file. But i would like to confirm that before proceeding.

Is this the 64 bit version of SQL Server??

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

no, for right now until we switch to SQL 2005, its the 32 bit version of 2000

pae is only required for 32bit os. What version of SQL Server are you running? Ent or Standard?

I am running the following with 32GB of RAM

Windows 2003 Enterprise x64
SQL 2000 SP4 SP4

IF you figure out how to use the counter logs to log SQL Server let me know....

Bert

its running on SQL 2000 Ent SP3
ill see about the logs

I am suprised it is even working.... You need SP4 to run SQL2000 on a x64 box....Why dont you apply Service Pack 4?

Bert

my mistake it is running sp4

i think you only need SP4 if you want support from MS, but still a good idea.
you may need to enable AWE on SQL Server
check the output of
sp_configure 'awe enabled'

fixed by applying hotfix for SP4
http://support.microsoft.com/default.aspx?kbid=899761