SQL2000 Ent. memory still 2gb issue....

[DLu]

Hi:

we just upgrade OS to Windows 2003 Ent version for a prod SQL2000 Ent. (sp4) server, and with 8 gb.

here is the boot.ini
----------------------
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOW S
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windo ws Server 2003, Enterprise" /pae /fastdetect /noexecute=optin
----------------------

1. past was 4 gb, with 3 gb to SQL
2. after re-start, from sql server properties--memory,
maximum server memory is 8187(in MB)
3. but from task manager, still allocate only 2 gb
(so actually, 'worse' than previous 3 gb)
4. from SQL log:
Message
Cannot use Address Windowing Extensions because lock memory privilege was not granted.
5. sql service log on with domain/admin
6. on windows Local Security Policy, add domain/admin to
a. Lock pages in memory
b. Log on as a service

Any part we were missing? Kind of urgent issue.
thanks in advance
David

[rmiao]

There is awe bug in sp4, should apply post sp4 hotfix.

[DLu]

Hi Ramiao:

thanks for the tip!
After cold boot the 8gb is there!

-D