Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 memory usage on 32 bit systems
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Constraint Violating Yak Guru

368 Posts

Posted - 01/11/2013 :  00:46:22  Show Profile  Reply with Quote
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.

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.

Posting Yak Master

160 Posts

Posted - 02/08/2013 :  18:58:21  Show Profile  Reply with Quote
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

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 02/09/2013 :  06:40:33  Show Profile  Visit jackv's Homepage  Reply with Quote
frank.svs - find a link for SQL Server 2005 memory configuration
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
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3873 Posts

Posted - 02/09/2013 :  07:37:32  Show Profile  Reply with Quote
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

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:

Edited by - James K on 02/09/2013 07:40:05
Go to Top of Page

Starting Member

15 Posts

Posted - 06/13/2013 :  02:14:32  Show Profile  Reply with Quote
Thanks for all good points.

Neeraj Prasad

Tutorial Sql Server
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000