Follow SQLMaster on Twitter
Welcome to SqlServer-QA.net Sign in | Help

TSQL to list the most used query plans

select  TOP 100
objtype,
p.size_in_bytes,
LEFT([sql].[text], 100) as [text]
from sys.dm_exec_cached_plans p
outer apply sys.dm_exec_sql_text (p.plan_handle) sql
ORDER BY usecounts DESC
Published Friday, September 28, 2007 1:12 AM by SQL Master

Comments

# TSQL to list the most used query plans

select TOP 100 objtype, p.size_in_bytes, LEFT([sql].[text], 100) as [text] from sys.dm_exec_cached_plans

Friday, September 28, 2007 1:41 AM by SSQA.net - SqlServer-QA.net

# TSQL to list the most used query plans

select TOP 100 objtype, p.size_in_bytes, LEFT([sql].[text], 100) as [text] from sys.dm_exec_cached_plans

Friday, September 28, 2007 2:21 AM by Other SQL Server Blogs around the Web
Anonymous comments are disabled