Hello, I would like to ask you a particular question, window’s task manager is not showing the correct memory usage by sql server. how to identify the exact memory usage from sql server? Please answer me by explaining me clearly.
Use the physical_memory_in_use_kb on the sys.dm_os_process_memory. Here's the strange thing – this query will indicate whether locked pages is enabled. If locked pages is enabled ,Task Manager may not show all the memory used by SQL Server.
1.
SELECT physical_memory_in_use_kb,locked_page_allocations_kb,
2.
memory_utilization_percentage
3.
FROM sys.dm_os_process_memory WITH (NOLOCK) OPTION (RECOMPILE);