- 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?