SQL Server 2005 64bit on 16GB machine uses 3.6GB memory only
- by ArjanP
Maximum server memory is set to the maxvalue
AWE is disabled (should not be needed in 64 bit anyway)
Windows Server 2008 Enterprise SP2
It is a virtual server using VMWare
If I look in Task Manager the sqlservr.exe process only uses about 3.6 GB of memory. Is that number not real? Shouldn't it attempt to use all available memory?
If I run DBCC MEMORYSTATUS I get:
VM Reserved 16670136
VM Committed 3640664
It looks like a memory limit I shouldn't be seeing in a 64 bit environment.. how can I get SQL2005 to use more memory?