Skip to content
«
»
 

Find Query Reuse (Execution Plan Reuse)

Posted by 
on  May 31 2009 
-- find counts of query re-use
SELECT * FROM
(
select *, (select object_name(objectid) from sys.dm_exec_sql_text(p.plan_handle)) AS SNAME
 from sys.dm_exec_cached_plans p
 where usecounts <= 1
--and objtype != 'adhoc' --and objtype != 'prepared'
) t
WHERE SNAME IS NOT NULL
 order by usecounts, size_in_bytes desc


Popular search terms:
Filed under DMV Queries
Comment (RSS)  |  Permalink

One Comment

  1. Appu says:
    May 14, 2012 at 4:25 am

    it’s very impotent to be aware of the reevesrd words, I built a cms that has a filed in each table called (CONDITION) and now its reevesrd in mysql 5.. it took me a lot of time to alter all the tables and the php code in all the sites that uses this cms Thanks Steve

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»