To View List of Memory Clerks
architecture #architecture#memory
select * from sys.dm_os_memory_clerks
--to view only unique but not duplicates, use the following command select distinct(type) from sys.dm_os_memory_clerks order by typeselect * from sys.dm_os_memory_clerks
--to view only unique but not duplicates, use the following command select distinct(type) from sys.dm_os_memory_clerks order by type