I have 8GB RAM on windows server 2003 enterprise 32 bits. From my computer, right click properties I can see 8GB.
However, i notice that my db instance can only use up to 1.6GB. (I didn't set max memory setting).
In order for my sql server 2005 (std edition 32 bits) instance to use more than 1.6GB memory, I understand that I will need to enable lock pages memory for the db service account and enable AWE in sql server.
However, do i need to add /PAE to my below boot.ini as well? What is the diff between /PAE and /3GB?
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /noexecute=optout