22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT usecounts ,
refcounts ,
size_in_bytes ,
cacheobjtype ,
objtype ,
TEXT
FROM (SELECT * FROM sys.dm_exec_cached_plans WHERE objtype = 'Adhoc') cp
CROSS APPLY sys.dm_exec_sql_text(plan_handle)
ORDER BY size_in_bytes DESC