SQL Server Query Plan

-- SQL Server Query Plan

select

cp.usecounts,
cp.cacheobjtype,
cp.objtype,
st.[text],
qp.query_plan

from

sys.dm_exec_cached_plans as cp

cross apply

sys.dm_exec_sql_text(plan_handle) as st

cross apply

sys.dm_exec_query_plan(plan_handle) as qp

order by

cp.usecounts desc;
go

dbcc

freeproccache;