Server uses up all memory
Posted on 2011-02-15
I have an issue with a Windows Server 2008 32bit server running SQL Server 2008. The server is a VM and has 4G of memory. The memory usage of the SQL server is limited to 2048MB. However when I check the task manager this morning then 3.92 G of the server are being used. The sql server service is using about 1.7G but there is nothing else being displayed what is using the memory. I also checked the with process explorer and the only process using lots of memory is sql server.
How can I figure out what is using and not releasing the other 2G of memory?