Capture Data from `sys.dm_os_memory_objects` & Build Dashboard for `Memory Objects`

[imajaydwivedi]

Capture Data from sys.dm_os_memory_objects & Build Dashboard for Memory Objects

SELECT type, SUM(pages_in_bytes) / 1024. / 1024 AS total_processrpc_memory_mb,
       MAX(max_pages_in_bytes) / 1024. / 1024 AS max_processrpc_memory_mb
FROM sys.dm_os_memory_objects
group by type
order by 2 desc,3 desc
go