0

I have a Windows server with 32 GB RAM, which is running sqlserver and tomcat.

In resource monitor it show more than 95% memory usage, but when I searched in processes all process, each process is consuming less than 500 MB memory.

Below are some of the top memory usage process from server.

Tomcat7 (SYSTEM)       360 MB
sqlservr (SYSTEM)      328 MB
w3wp (NETWORK SERVICE) 302 MB
chrome (devel)         283 MB
svchost (SYSTEM)       266 MB
javaw (devel)          247 MB
......                 146 MB
Ssms (devel)           80 MB
NewRelic.ServerMonitor 69 MB
java (SYSTEM)          65 MB
...... (SYSTEM)        62 MB
explorer (devel)       54 MB
....... (devel)        49 MB
....... (SYSTEM)       40 MB
svchost                26 MB
....... (SYSTEM)       26 MB
WmiPrvSE               24 MB
services (SYSTEM)      9 MB
........ (devel)       6 MB

How do I find the process which is invisible in task manager but consuming all the memory?

  • 3
    Use VMMap and RAMMap from live.sysinternals.com. They give a much more detailed, granular picture of what's going on with both your physical and your virtual memory than Task Manager does. – Ryan Ries Jul 24 '14 at 12:54
  • 2
    This does not seem to be a production system, but a development system, because you are running chrome, SQL Server and IIS/Tomcat on the same machine, as well as SQL Server Management Studio. Development systems are off-topic here on serverfault.com – MichelZ Jul 24 '14 at 13:00
  • 1
    post some pictures of RAMMap (technet.microsoft.com/en-us/sysinternals/ff700229.aspx) – magicandre1981 Jul 24 '14 at 19:18
6

Usually, SQL Server grabs all the memory that it can, even if it's not listed in Task/Resource manager.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.