Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2008-07-25 : 10:39:46
|
| All: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 GBSQL 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 switchOn SQL Server Enable AWE and set the MAx Server Memory to 14 GBThanks ! |
|
|
pootle_flump
1064 Posts |
Posted - 2008-07-25 : 11:03:03
|
| That will set 1GB max for OS. 3GB for SQL Server, and, I suppose, 10GB for the SQL Server data cache.You can only have 4 GB for the OS and applications. By default this is 2GB for OS and 2 GB for other services. You don't need to set the 3GB switch if you want 2GB for OS - but apart from allowing allocation of memory for the data cache I don't know why you would.NOTE - I'm no hardware expert, others might know better. Best article I know on this (in case you haven't seen):http://blogs.msdn.com/chadboyd/archive/2007/03/24/pae-and-3gb-and-awe-oh-my.aspx |
 |
|
|
pootle_flump
1064 Posts |
Posted - 2008-07-25 : 11:09:51
|
Hmm - reread my point re /3GB.The point I'm trying to make is 2GB is (TMK) the maximum your OS can use. 4GB is all the OS and applications can use in total. The /3GB switch changes this to 1GB for the OS and 3GB for applications. It doesn't increase the memory available - just the distribution. PAE & AWE allows SQL Server to address memory for the data cache. However, this addressing is via the OS memory allocation so it will eat into the 1GB chunk of memory the OS is using (if you use the /3GB switch).Is that more coherent?  |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-26 : 21:17:00
|
| >> 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.Then you can't put /3gb in boot.ini file. Enable awe and set max memory in sql to 14gb. |
|
|
|
|
|
|
Memory Configuration and /3GB /PAE