How do I determine the proper max memory setting for our system? We have Windows server 2003 R2 entreprise ed, sp2. It is 32 bit. There is 8.00 Gb of ram. We have just upgraded to SQL Server 2008 sp1, enterprise ed. Now we're having some memory problems. Thanks very much for any help with this.
Software/Hardware used: Windows Server 2003 R2 Enterprise ed. Service Pack 2, SQL Server 2008 sp1 Enterprise ed.