We have a new Windows server and are working on configuring the memory. Read a lot about /3GB , /PAE , AWE and got a little bit confused so thought I will post it here and see what do you folks thinks how I am going to configure?
Our New Windows Environment.
Windows 2003 Enterprise Edition (32 bit)
Memory - 16 GB
SQL 2005 Enterprise Edition (32 bit)
I would like to give not more than 2 GB for the OS / Kernel (14 GB we want for SQL) and based on that here is what I am planning to configure. Let me know if I am right or wrong?
On Windows Enable the /3GB /PAE switch
On SQL Server Enable AWE and set the MAx Server Memory to 14 GB