David Benoit (8/13/2010)
GilaMonster (8/13/2010)
4GB is the maximum amount of memory a 32 bit app can use running on a 64 bit OS.Thanks Gail. Hate to think that this is what they did but I can see where you would come to that conclusion.
I had a recent situation with a client of mine, they told me they were running SQL 2005 x64. I was doing a perf tuning exercise and, from the data I had it was clear that SQL needed more memory. I checked perfmon and SQL was using 4GB out of 16 GB. I checked the SQL error log. Right at the top:
Microsoft SQL Server 2005 - 9.00.3042 (X86)
Person who had installed SQL had installed the 32 bit instead of 64 bit, and no one had checked.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability