dm_os_memory_objects

• SQLAssAS

  SSCertifiable

  Points: 7246

  More actions

  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

• SQLAssAS

  SSCertifiable

  Points: 7246

  More actions

  January 26, 2017 at 9:46 am

  #1925107

  Any ideas anyone?

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  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