AWE memory available in SQ 2008 Standard 32-bit?

• Indianrock

  SSC-Insane

  Points: 20333

  More actions

  September 11, 2009 at 11:32 am

  #210637

  Can you use the AWE address window extensions on SQL 2008 Standard 32bit running on Windows 2003 Enterprise Edition. This will probably have 32GB of memory available.

• Marcin Gol

  Hall of Fame

  Points: 3314

  More actions

  September 11, 2009 at 4:05 pm

  #1052600

  it depends 😉

  SQL Standard can use all of memory which OS can see. So if you have Windws 2003 Ent (x64/x86) or Windows 2003 Std (x64) you can use 32GB ram.

  if you are using 32bit os - you should place /PAE switch to the boot.ini

  - in this case you SHOULDNT use /3GB or /USERVA switches

  And last, but not least - you reeealy should set max server memory option