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 |
|
sridards
Starting Member
6 Posts |
 Posted - 2010-11-03 : 01:07:52
|
| Hi,I need some clarification regarding sqlserver memory utilisation.I have windows 2003 - 32 bit with 8 GB RAM. Normally windows with 32 bit allows only upto 4 GB, and windows is not taking above 4GB and shows only upto 4GB in hardware configuration.My question is Whether the remaining 4GB will be used for SQL server or not? i.e., if i specify in sqlserver 2008 R2 memory configuration -"Max Server Memory" as 6GB, will it be taken in to account with full 6GB? or will it take only maximum memory which windows can accomodate?Please clarify as soon as possible.ThanksS.Sridhar |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-11-03 : 18:47:32
|
| SQL Server can only access as much memory as the OS presents. Since the OS is only seeing 4GB of the available 8GB of memory, then all SQL Server can access is that 4GB.To make the other 4GB available - you need to enable /PAE in the boot.ini. Once that is done and the server restarted, Windows should see the additional memory. Once the additional memory is available to the OS, then SQL Server will be able to use it. However, for SQL Server to access that memory - you'll need to enable AWE in SQL Server.Jeff |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-11-08 : 04:47:53
|
| Also if you are enabling AWE - add the SQL Server start up account to the Lock Pages in Memory.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Sqlserver - Windows 32 bit - 8 GB RAM