I do have a server 2008 64 running a SQL server 2005. I do have 8GB on the server and I want SQL to use most of the memory on that server. I have turned the page-locking on for the account and also turned AWE on. See the result below:
Configuration option 'min server memory (MB)' changed from 0 to 1024. Run the RECONFIGURE statement to install.
Configuration option 'max server memory (MB)' changed from 5113 to 6144. Run the RECONFIGURE statement to install.
However it does not seem that SQL server is loading the memory. Not sure what I am missing. I would appreciate if someone could lead me on the right direction.