I am running SQL Server 2005 Standard x64 on Windows server 2003 R2 x64. I have 32GB of total server RAM. I am unable to make SQL Server use more than 3 GB of memory, even I set min and max server options as follows:
sp_configure 'show advanced options', 1 RECONFIGURE GO sp_configure 'min server memory', 1024 RECONFIGURE go sp_configure 'max server memory', 24576 RECONFIGURE GO
What could be a problem?
There was SQL Server 2005 32bit installed. See my answer.