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 |
|
mvmanohar
Starting Member
2 Posts |
 Posted - 2008-07-01 : 13:28:06
|
| Assume that 4GB of RAM is available on server and to utilize 3GB for SQL Server then we need to put /3GB switch in boot.ini file. That means by adding the /3GB switch (and restarting), Windows will allocate just 1Gb to the kernel mode address space, allowing a process’s user mode address space to increase to 3Gb.Now please tell me how much GB will be used for kernel and user address spaces, if 8GB RAM is available on the server (/3GB switch exists in boot.ini). |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-01 : 23:03:29
|
| Same as machine with 4gb memory, but certain apps like sql server may able to use memory above 4gb range by putting /pae in boot.ini file. That means sql enterprise edition can use up to 7gb memory when awe is enabled. |
 |
|
|
mvmanohar
Starting Member
2 Posts |
Posted - 2008-07-03 : 10:14:57
|
| So, you mean to say that for 8GB RAM (/3GB switch exists in boot.ini) , Kernel mode address space utilizes 1GB and processes user mode address space utilizes 3GB. If we use /PAE switch along with /3GB switch in boot.ini file then Kernel mode address space utilizes 1GB and processes user mode address space utilizes 7GB.MY UNDERSTANDING IS CORRECT??? |
|
|
|
contrari4n
Starting Member
27 Posts |
Posted - 2008-07-03 : 17:01:03
|
| You are correct provided the application can address it.I guess you are using SQL Server 2000 as this is a 2000 forum. Enterprise Edition can use all 7GB if AWE is enabled.Bear in mind that you should not use the /3GB switch with more than 16GB, or only the first 16GB will be addressable.Richard Fryarhttp://www.sql-server-pro.comSQL Server Articles and Tips |
|
|
|
|
|
|
Clarity on /3GB switch