The Memory Usage and Virtual Memory counters shown in Task Manager for SQL Server 2005 64bit are incorrect.
We are running SQL Server 2005 64bit Developer Edition x64 with SP2 on Windows 2003 64bit R2. The server is a HP DL585 with 4xAMD Opteron processor with 24Gb of RAM. The amount of memory should in the task manager for physical and virtual memory is incorrect.
We have configured SQL Server 2005 to use minumum of 2GB and maximum of 10Gb. But the memory should in task manger is less than 1GB. This is clearly incorrect as the Commit Charge doesn't add up to the memory should for all the processes.
The vitual memory for all the process adds up to about about 4GB, but the commit charge is 14GB. SQL Server 2005 is only showing 200MB. Stopping SQL Server 2005 makes the commit charge drop by 10GB, and starting SQL Server 2005 increases the memory. After running some DBCC CHECKDB or other SQL commands the commit charge rises back up to 14Gb, but SQL is still showing 200MB.
There is clearly a problem with SQL Server 2005 64 bit understating the about of memory in use in Task Manager.