Search notes:

SQL Server - sys.dm_os_memory_objects

select
   memory_object_address,
   parent_address,
   pages_in_bytes,
   creation_options,
   bytes_used,
   type,
   name,
   memory_node_id,
   creation_time,
   page_size_in_bytes,
   max_pages_in_bytes,
   page_allocator_address,
   creation_stack_address,
   sequence_num,
   partition_type,
   partition_type_desc,
   contention_factor,
   waiting_tasks_count,
   exclusive_access_count
from
   sys.dm_os_memory_objects

Object types

select
   type
-- COUNT(*)
from
   sys.dm_os_memory_objects
group by
   type
order by
   type
-- -- MEMOBJ_APPENDONLYSTORAGEUNITMGR -- MEMOBJ_APPLOCKLVB -- MEMOBJ_ASYNCHSTATS -- MEMOBJ_AUDIT_EVENT_BUFFER -- MEMOBJ_AUDIT_MGR -- MEMOBJ_BADPAGELIST -- MEMOBJ_CACHEOBJPERM -- MEMOBJ_CACHESTORE_BROKERUSERCERTLOOKUP -- MEMOBJ_CACHESTORE_XML_SELECTIVE_DG -- MEMOBJ_CACHESTOREBROKERDSH -- MEMOBJ_CACHESTOREBROKERKEK -- MEMOBJ_CACHESTOREBROKERREADONLY -- MEMOBJ_CACHESTOREBROKERRSB -- MEMOBJ_CACHESTOREBROKERTBLACS -- MEMOBJ_CACHESTOREOBJCP -- MEMOBJ_CACHESTOREPHDR -- MEMOBJ_CACHESTOREQNOTIFMGR -- MEMOBJ_CACHESTORESEHOBTCOLUMNATTR -- MEMOBJ_CACHESTORESQLCP -- MEMOBJ_CACHESTORESXC -- MEMOBJ_CACHESTORETEMPTABLE -- MEMOBJ_CACHESTORETOKENPERM -- MEMOBJ_CACHESTOREVENT -- MEMOBJ_CACHESTOREVIEWDEFINITIONS -- MEMOBJ_CACHESTOREXMLDBATTRIBUTE -- MEMOBJ_CACHESTOREXMLDBELEMENT -- MEMOBJ_CACHESTOREXMLDBTYPE -- MEMOBJ_CACHESTOREXPROC -- MEMOBJ_COLUMNSTOREOBJECTPOOL -- MEMOBJ_COMPILE_ADHOC -- MEMOBJ_CONVPRI -- MEMOBJ_CSILOB_XPRESS_BLOCK -- MEMOBJ_DBMIRRORING -- MEMOBJ_DEADLOCKXML -- MEMOBJ_DIAGNOSTIC -- MEMOBJ_ENTITYVERSIONINFO -- MEMOBJ_EVENTSUBSYSTEM -- MEMOBJ_EXCHANGEPORTS -- MEMOBJ_EXCHANGEXID -- MEMOBJ_EXECUTE -- MEMOBJ_FILETABLE_NSO -- MEMOBJ_FILETABLE_STORE -- MEMOBJ_FSAGENT -- MEMOBJ_FSCHUNKER -- MEMOBJ_FULLTEXTGLOBAL -- MEMOBJ_FULLTEXTSTOPLIST -- MEMOBJ_GLOBALPMO -- MEMOBJ_HADR -- MEMOBJ_HKCS_MAINTENANCE -- MEMOBJ_HOST -- MEMOBJ_HTTPSNICONTROLLER -- MEMOBJ_INDEXRECMGR -- MEMOBJ_INDEXSTATSMGR -- MEMOBJ_LBSSCACHE -- MEMOBJ_LMCACHE -- MEMOBJ_LOCKBLOCKS -- MEMOBJ_LOCKOWNERS -- MEMOBJ_LOGPOOL -- MEMOBJ_METADATADB -- MEMOBJ_OPTINFOMGR -- MEMOBJ_PARSE -- MEMOBJ_PERDATABASE -- MEMOBJ_PROCCACHEPARTITIONEDHEAP -- MEMOBJ_PROCESSRPC -- MEMOBJ_QDSRUNTIMESTATSCACHE -- MEMOBJ_QDSSTMTCACHE -- MEMOBJ_QPMEMGRANTINFO -- MEMOBJ_QSCANSORTNEW -- MEMOBJ_QUERY_DRIVER -- MEMOBJ_QUERYDISKSTORE -- MEMOBJ_QUERYEXECCNTXTFORSE -- MEMOBJ_QUERYNOTIFICATON -- MEMOBJ_QUERYSTOREPARTITIONEDHEAP -- MEMOBJ_QUERYSTORESTATS -- MEMOBJ_RECOVERYDPTFACTORY -- MEMOBJ_REMOTESESSIONCACHE -- MEMOBJ_REPLICATION -- MEMOBJ_RESOURCE -- MEMOBJ_RESOURCESEINTERNALTLS -- MEMOBJ_RESOURCESUBPROCESSDESCRIPTOR -- MEMOBJ_RESOURCEXACT -- MEMOBJ_RULETABLEGLOBAL -- MEMOBJ_SBACTIVATIONMANAGER -- MEMOBJ_SBASBMANAGER -- MEMOBJ_SBMESSAGEDISPATCHER -- MEMOBJ_SBOBJECTPOOLS -- MEMOBJ_SBTIMEREVENTCACHE -- MEMOBJ_SBTRANSPORT -- MEMOBJ_SCHEMAMGRHEAP -- MEMOBJ_SCTCLEANUP -- MEMOBJ_SEARCHPROPERTYLIST -- MEMOBJ_SECOLMETACACHE -- MEMOBJ_SECURITY -- MEMOBJ_SERVICEBROKER -- MEMOBJ_SERVICEBROKERTRANSOBJ -- MEMOBJ_SESCHEMAMGR -- MEMOBJ_SNI -- MEMOBJ_SNIPACKETOBJECTSTORE -- MEMOBJ_SORTTABLE -- MEMOBJ_SOSBOOT -- MEMOBJ_SOSDEADLOCKMONITOR -- MEMOBJ_SOSDEADLOCKMONITORRINGBUFFER -- MEMOBJ_SOSDEADLOCKMONITORXMLREPORT -- MEMOBJ_SOSNODE -- MEMOBJ_SOSSCHEDULER -- MEMOBJ_SOSSCHEDULERMEMOBJPROXY -- MEMOBJ_SOSSCHEDULERTASK -- MEMOBJ_SOSWORKER -- MEMOBJ_SP_SERVER_DIAGNOSTICS_DEADLOCK_MONITOR -- MEMOBJ_SPATIAL -- MEMOBJ_SQLCLR_CLR_EE -- MEMOBJ_SQLCLR_VMSPY -- MEMOBJ_SQLCLRHOSTING -- MEMOBJ_SQLEXTENSIBILITY_SERVERCONTEXT -- MEMOBJ_SQLMGR -- MEMOBJ_SQLTRACE -- MEMOBJ_SRVPROC -- MEMOBJ_STACKSTORE -- MEMOBJ_STORAGEMANAGEMENT -- MEMOBJ_SVL -- MEMOBJ_SYNCPOINT -- MEMOBJ_SYSTASKSESSION -- MEMOBJ_SYSTEMROWSET -- MEMOBJ_TEMPORAL_MAINTENANCE -- MEMOBJ_VIEWDEFINITIONS -- MEMOBJ_XACT_CACHE -- MEMOBJ_XE_ENGINE -- MEMOBJ_XP -- MEMOBJ_XTPBLOCKALLOC -- MEMOBJ_XTPPROCCACHE -- MEMOBJ_XTPPROCPARTITIONEDHEAP -- MEMOBJ_XTPTHREADPOOL

Index