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 |
|
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 bitSQL server 2005 sp4 32 bit 64 GB Physical RAM1. /3GB + AWE 2. /PAE + AWE3. /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 96GBfor 32 GB RAM, it should be 48GB |
 |
|
|
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.htmlSome 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 memoryJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
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/ |
|
|
|
neeraj_sharma
Starting Member
15 Posts |
|
|
|
|
|
memory usage on 32 bit systems