How to check what is using memory..

  • Hello,

    Can anybody tell me what should i do to check what is exacly using memory in my SQL Server Instance.

    Another question, how can i check what part of memory is really used by SQL Server of the amount of memory that i defined in Server Memory Options.

    I try to use dbcc memorystautus but i dont understand what kind of results should i expect.

    Then i run this query but i've got the same problem.

    Can anybody explain this to me or send me links where i can check this points?

    select

    type,

    sum(virtual_memory_reserved_kb) as [VM Reserved],

    sum(virtual_memory_committed_kb) as [VM Committed],

    sum(awe_allocated_kb) as [AWE Allocated],

    sum(shared_memory_reserved_kb) as [SM Reserved],

    sum(shared_memory_committed_kb) as [SM Committed],

    sum(multi_pages_kb) as [MultiPage Allocator],

    sum(single_pages_kb) as [SinlgePage Allocator]

    from

    sys.dm_os_memory_clerks

    group by type

    Thanks and regards,

    JMSM 😉

Viewing 0 posts

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