Browse by Tags

All Tags » query » sql server » execution (RSS)
TSQL to list the most used query plans
Published 28 September 7 3:12 AM | SSQA.net
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...( read more ) Read More...
Filed under: , , , , ,