Post reply

Troubleshoot high SQL Server Memory usage

  • February 22, 2016 at 6:18 am

    #1860060

    SQL!$@w$0ME (2/20/2016)

    I was not able to find a script to troubleshoot this particular issue.

    http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-january-2016/

    @ around like 164 in the 2014 script, there's this:

    -- SQL Server Process Address space info (Query 6) (Process Memory)

    -- (shows whether locked pages is enabled, among other things)

    SELECT physical_memory_in_use_kb/1024 AS [SQL Server Memory Usage (MB)],

    large_page_allocations_kb, 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);

    -- You want to see 0 for process_physical_memory_low

    -- You want to see 0 for process_virtual_memory_low

    -- This indicates that you are not under internal memory pressure

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply