Author Topic: Window's task manager is not showing the correct memory usage by SQL Server. How to identify the exact memory usage from SQL Server?  (Read 154 times)

Offline Quinn

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
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.
« Last Edit: May 01, 2017, 01:13:00 PM by Sofyene »



Offline Keegan

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: Manager is not showing the correct memory
« Reply #1 on: May 01, 2017, 01:13:22 PM »
Use the physical_memory_in_use_kb on the sys.dm_os_process_memory. Heres 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);


 

Sitemap 1 2 3 4 5 6 7 8 9