select 
      pool_id,
      sum(size_in_bytes) as [size_in_bytes],
      count(1) as [number_of_entries],
      cacheobjtype, 
      objtype
from sys.dm_exec_cached_plans
group by pool_id, cacheobjtype, objtype

CREATE EVENT SESSION [recompiles] ON SERVER 
ADD EVENT sqlserver.compilation_stage_statistics
,ADD EVENT sqlserver.query_cache_removal_statistics
--,ADD EVENT sqlserver.sql_statement_post_compile --не помню добавлено ли оно для 2012  версии
--,ADD EVENT sqlserver.sql_statement_recompile
WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
GO