SQL Server 2008 R2 “Ghost Memory”?
- Windows Server 2008 R2;
- 32GB RAM;
- Application: SQL Server 2008 R2, several Connectors to Write Data into SQL Server(Write Frequency: 0.5HZ);
- The Server has not been restart for more than half a year;
- About 15G Data per month;
- Support Several Applications hosted on other Server(Web Applicaion, Socket Application);
Problem(From the Task Manager): In the Performance Tab, The Memory Display and the Physical Memory Usage History Chart both show that the memory usage is approaching 100%(96%); While in the Process Tab, in which the Memory(Private Working Set) Column is shown by default, and the Memory(Private Working Set) Usage of sqlservr.exe is realtively small(200-300M), the total Memory(Private Working Set) usage of all the Processes added up is normal as well(less than 10%).
Maybe the problem is that I just check the Memory(Private Working Set) Column, but I don't have access to the Server right now