Post reply

dm_os_memory_objects

  • January 25, 2017 at 9:31 am

    #318176

    So if you run the following, it clearly shows which parts of SQL are using the most memory.

    SELECT SUM (pages_in_bytes) as 'Bytes Used', type 
    FROM sys.dm_os_memory_objects
    GROUP BY type 
    ORDER BY 'Bytes Used' DESC;
    GO

    Does anyone have an article anywhere ( i have searched the net!) for what each 'type' actually is? Specifically MEMOBJ_SOSWORKER

    cheers

  • January 26, 2017 at 9:46 am

    #1925107

    Any ideas anyone?

  • January 26, 2017 at 6:11 pm

    #1925217

    SQLAssAS - Thursday, January 26, 2017 9:46 AM

    Any ideas anyone?

    No docs that I could find but for MEMOBJ_SOSWORKER I was guessing its the SOS worker threads.
    Run these queries and note the memory_object_address. And the counts.

    SELECT *
    FROM sys.dm_os_memory_objects
    WHERE type like 'MEMOBJ_SOSWORKER'
    ORDER BY memory_object_address'

    And compare  these to the DMV for the worker threads:
    SELECT memory_object_address, *
    FROM sys.dm_os_workers w
    ORDER BY w.memory_object_address

    Sue

Viewing 3 posts - 1 through 2 (of 2 total)

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