Resource Monitor Memory Usage

Question

Hello everybody,

I have opened "Resource Monitor" on a server, memory tab, to view detailed memory consumed by the processes. As you can see the values are as follows:

This VM is dedicated to SQL Server service. The "In Use" value is about 30300 MB which is also reported by the OS in the task manager as the memory usage percentage. I exported all the tasks to an Excel file. The tail of the resulting table and the summation of the memory columns values is the following:

None of these summations match the "In Use" value. Even if you take "commit" column, there is still about 10 GB missing. Moreover, there are no other memory columns available to be added for monitoring. Where does this 10 GB go? I need the actual usage value of every process that adds up to "In Use" value. How can I explain this discrepancy or find the information I need? My ultimate purpose is to make physical memory available to SQL Server as much as possible. The result of the following query also comes next if it can be of any help:

SELECT

sqlserver_start_time,

cpu_count,

physical_memory_kb/1048576.0 Total_Physical_Memory_GB,

virtual_memory_kb/1048576.0 Total_Virtual_Memory_GB,

(committed_kb/1048576.0) AS SQL_Used_Memory_GB,

(committed_target_kb/1048576.0) AS SQL_Target_Memory_GB,

visible_target_kb/1048576.0 SQL_Visible_Target_Memory_GB

FROM sys.dm_os_sys_info

I appreciate your help very much.

Regards,

Ali

Answer 1

As I guessed, there was a problem with virtualization configurations.