Oracle_91 (1/10/2013)
1. /3GB + AWE
This would allow SQL to use no more than 3GB of memory, as enabling AWE required the PAE switch to be on
3. /PAE + /3GB + AWE
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability