InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:53:29 GMT20http://www.sqlservercentral.com/Forums/Topic1405762-360-1.aspxFrom Books Online:[quote]If there is more than 16 GB of physical memory available on a computer, the operating system requires 2 GB of virtual address space for system purposes and therefore can support only a 2 GB user mode virtual address space. For the operating system to use the memory range above 16 GB, be sure that the /3gb parameter is not in the Boot.ini file. If it is, the operating system cannot use any physical memory above 16 GB.[/quote]Sat, 12 Jan 2013 05:47:10 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1405762-360-1.aspxHi,Thanks for sharing your thoughts.Gila, I have a question, how does the calucation comes to 16Gigs If I have to choose /PAE + /3GB + AWE ?Thank you.Sat, 12 Jan 2013 05:28:08 GMTOracle_91http://www.sqlservercentral.com/Forums/Topic1405762-360-1.aspx[quote][b]Oracle_91 (1/10/2013)[/b][hr]1. /3GB + AWE [/quote]This would allow SQL to use no more than 3GB of memory, as enabling AWE required the PAE switch to be on[quote]3. /PAE + /3GB + AWE [/quote]This option would allow no more than 16 GB of memory to be used and would risk OS instability and fun memory errors (lack of available page table entries)/3GB is fine with just 4 GB of memory, OK with 8, risky with 16 and silly with anything above that.Fri, 11 Jan 2013 05:46:50 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1405762-360-1.aspx[quote][b]Oracle_91 (1/10/2013)[/b][hr]Hi All,Can anyone share their expericences which one is good and bad about below configurations on 32 bit systems and sql server 2005.On what factors we can choose either of the below and which one would be a best match based on the scenario whether it is MTL or Bpool pressure? Also, would like to know how much memory can i make use of below physical RAM if it is 64 gigs or 32 gigs.Environment Windows 2003 32 bitSQL server 2005 sp4 32 bit 64 GB Physical RAM1. /3GB + AWE 2. /PAE + AWE3. /PAE + /3GB + AWE Looking forward for lot of answers....Thanks in advance.[/quote]Use option 2 if you have 64 GB of RAM. It will allow you to access all 64 GB. Make sure you set the max memory option using sp_configure to something sensible to allow the OS some memory to do its work, else SQL Server will try to consume all memory.Fri, 11 Jan 2013 05:36:21 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1405762-360-1.aspxHi All,Can anyone share their expericences which one is good and bad about below configurations on 32 bit systems and sql server 2005.On what factors we can choose either of the below and which one would be a best match based on the scenario whether it is MTL or Bpool pressure? Also, would like to know how much memory can i make use of below physical RAM if it is 64 gigs or 32 gigs.Environment Windows 2003 32 bitSQL server 2005 sp4 32 bit 64 GB Physical RAM1. /3GB + AWE 2. /PAE + AWE3. /PAE + /3GB + AWE Looking forward for lot of answers....Thanks in advance.Thu, 10 Jan 2013 22:47:17 GMTOracle_91