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
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
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/
memory usage on 32 bit systems
Posted - 01/11/2013 : 00:46:22
