sql SQL Server Memory Use

SELECT
	physical_memory_in_use_kb As KB,
	physical_memory_in_use_kb / 1024 As MB,
	((physical_memory_in_use_kb / 1024) / 1024) As GB,
	locked_page_allocations_kb, 
    page_fault_count,
	memory_utilization_percentage, 
    available_commit_limit_kb,
	process_physical_memory_low, 
    process_virtual_memory_low
FROM sys.dm_os_process_memory WITH (NOLOCK) OPTION (RECOMPILE);
Task Manager incorrectly reports the Memory usage of SQL Server: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6583a6ba-9ff6-4de9-af0e-3a64df6f9e9b/sqlserverexe-only-100k-in-task-manager-but-uses-18gb?forum=sqldatabaseengine

Updated: Thursday 26th September 2019, 06:15pm

Share Snippet

There are 0 comments

Leave a comment of your own

Comments are currently closed.