Physical memory usage approaching 100%(96%) Possible Duplicate:
  SQL Server 2008 R2 &ldquo;Ghost Memory&rdquo;?  




Context:


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);


Edit:


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
is there some kind of memory-leak problems here?


No, the problem is more someone who does not know how SQL Server works.

SQL Server uses as much memory as feasible as cache for the database. Why not use it? So, what happens basically is that SQ LServer has a lot of data in memory in case it needs it, to avoid accessing the disc.

If you need more free memory, set a memory limit in SQL Server properties.

If oot - be happy, your memroy is used.