I have read quite a few articles that recommend turning on /3GB on a server with 32bit SQL server and 32bit Windows 2003 standard where you have between 4GB and 16GB or RAM. Why is /3GB needed? Just so SQL Server can have more VAS, and because VAS is better than AWE mapped memory? This switch effectively limits your kernel to 1GB right? Why put the limit on if you have 6 extra GB for SQL Server?
Windows 2003 Standard 32bit, SQL 2005 Standard 32bit
September 23, 2009 8:49 PM
September 26, 2009 1:15 AM