SELECT  COUNT (*) 
FROM    sys.dm_exec_cached_plans AS cp
        where cp.size_in_bytes/1024 > 8

SELECT  COUNT (*)
FROM    sys.dm_exec_cached_plans AS cp
        where cp.size_in_bytes/1024 < = 8

SELECT TOP(20) [type], [name], SUM(single_pages_kb)/1024 AS [SPA Mem, Mb] 
FROM sys.dm_os_memory_clerks 
GROUP BY [type], [name]  
ORDER BY SUM(single_pages_kb) DESC;

SELECT SUM(multi_pages_kb)/1024 AS [MPA Mem, Mb] 
FROM sys.dm_os_memory_clerks 

SELECT SUM(single_pages_kb)/1024 AS [SPA Mem, Mb] 
FROM sys.dm_os_memory_clerks