December 22, 2009 at 12:29 pm
Hi everyone,
I just installed Sql 2005 Enterprise on a new server running on Windows 2003 Server Enterprise x86 (32bit)
The server has 24 gig of RAM.
In the SQL server properties, under the Memory page the "Maximum server memory (in MB)" value is: 2147483647
This looks like the value is listed in Bytes even if the field says (in MB)...
I also checked the "use AWE to allocate memory" checkbox.
I would like to know if SQL 2005 will be able to use all the memory. Is it going to be limited to 2GB or 3GB if I use the /3GB switch ?
Thanks for your answers !
December 22, 2009 at 12:42 pm
If you are using SQL Server 2005 to configure memory to use more than 2 GB of physical, see the following topics in SQL Server 2005 Books Online:
Memory Architecture
Server Memory Options
Using AWE
Enabling Memory Support for Over 4 Gb of Physical Memory
Enabling AWE Memory for SQL Server
The following article also has some useful info.
http://www.sqlmag.com/article/articleid/49588/49588.html
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2009 at 1:02 pm
I would also configure the maximum memory for SQL Server to 20 GB (20480 MB), leaving 4 GB RAM for the OS. Are there any other applications running on the server; Anti-virus, etc? If so, you may want to reduce the maximum memory used from there.
December 22, 2009 at 11:16 pm
I would second Lynn's note. If you have more than 16GB on the 32 bit platform, the OS needs quite a bit.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply