select usecounts,cacheobjtype,objtype,query.text,executionplan.query_plan from sys.dm_exec_cached_plans outer apply sys.dm_exec_sql_text(plan_handle) as query outer apply sys.dm_exec_query_plan(plan_handle) as executionplan where text not like '%sys%'and cacheobjtype ='compiled plan'

select usecounts,cacheobjtype,objtype,query.text,executionplan.query_plan from sys.dm_exec_cached_plansouter apply sys.dm_exec_sql_text(plan_handle) as queryouter apply sys.dm_exec_query_plan(plan_handle) as executionplanwhere text not like '%sys%'and cacheobjtype ='compiled plan'

Return Cached Query Plans

query

SQL