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