SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

frank.svs
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.

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 - 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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 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 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
Flowing Fount of Yak Knowledge

3699 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 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/

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

neeraj_sharma
Starting Member

India
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  
 New 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.12 seconds. Powered By: Snitz Forums 2000