query execution count

queryexecutioncount.sql

--DBCC TRACEON(8666)
--GO

SELECT qt.text [Comando],
       CP.usecounts [Qtd Executado],
     cp.size_in_bytes [TamanhoBytes],
	   cp.objtype [TipoConsulta],
	   qp.query_plan [ExecutionPlan]
FROM sys.dm_exec_cached_plans cp
    CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) qp
    CROSS APPLY sys.dm_exec_sql_text (cp.plan_handle) qt
WHERE qt.text LIKE '%termo%' and qt.text not LIKE '%sys.dm_exec_cached_plans%'

--dbcc freeproccache

 --DBCC TRACEOFF(8666)
 --GO