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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 memory usage on 32 bit systems

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2013-01-11 : 00:46:22
Hi All,

Can anyone share their expericences which one is good and bad about below configurations on 32 bit systems and sql server 2005.
On what factors we can choose either of the below and which one would be a best match based on the scenario whether it is MTL or Bpool pressure?
Also, would like to know how much memory can i make use of below physical RAM if it is 64 gigs or 32 gigs.

Environment
Windows 2003 32 bit
SQL server 2005 sp4 32 bit
64 GB Physical RAM

1. /3GB + AWE
2. /PAE + AWE
3. /PAE + /3GB + AWE

Looking forward for lot of answers....

Thanks in advance.

srimami
Posting Yak Master

160 Posts

Posted - 2013-02-08 : 18:58:21
Windows suggests to go with 1.5 Times the actual RAM

For 64 GB RAM, it should be 96GB
for 32 GB RAM, it should be 48GB
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-09 : 06:40:33
frank.svs - find a link for SQL Server 2005 memory configuration http://www.sqlserver-dba.com/2010/10/sql-server-2005-memory-configuration-management.html
Some key points include:
1)limit the SQL Server max memory.
2)I'd also suggest you size out the memory requirements of all other apps on the server - such as virus scanner, agents etc - which may steal memory

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-09 : 07:37:32
A very good and thorough discussion of this topic, along with recommended settings, what you need to monitor if you want to live on the edge etc. is available in the book "Professional SQL Server 2008 Internals and Troubleshooting" by Christian Bolton et.al.

Editing: There is SQL 2012 version of the same book. That has only a brief discussion of 32-bit systems (probably because there are fewer and fewer 32 bit systems as each day goes by). So if you are going to get Bolton's book for this purpose, be sure to get the 2008 version - this is the amazon link: http://www.amazon.com/Professional-Server-2008-Internals-Troubleshooting/dp/0470484284/
Go to Top of Page

neeraj_sharma
Starting Member

15 Posts

Posted - 2013-06-13 : 02:14:32
Thanks for all good points.



Neeraj Prasad

Tutorial Sql Server
Go to Top of Page
   

- Advertisement -