InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 05:31:13 GMT20http://www.sqlservercentral.com/Forums/Topic1429622-360-1.aspxthanks allMon, 18 Mar 2013 23:56:16 GMTchewychewyhttp://www.sqlservercentral.com/Forums/Topic1429622-360-1.aspxYou might like to look at [url]http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20AWE%20Property[/url] for more details of how the AWE property works.Wed, 13 Mar 2013 03:41:23 GMTEdVassiehttp://www.sqlservercentral.com/Forums/Topic1429622-360-1.aspxAdd /PAE to the boot.ini. Grant locked pages, enable AWE./PAE - allow memory usage above 4GB (32 bit limit)/3GB - change the kernal/user memory division from 2GB/2GB to 1GB/3GB.Tue, 12 Mar 2013 04:18:07 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1429622-360-1.aspxHi Guys,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?thanks![boot loader]timeout=30default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS[operating systems]multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /noexecute=optoutTue, 12 Mar 2013 03:05:52 GMTchewychewy