1 SELECT st.text as sql_statement, 2 qs.creation_time as plan_last_compiled, 3 qs.last_execution_time as plan_last_executed, 4 qs.execution_count as plan_executed_count, 5 qp.query_plan 6 FROM sys.dm_exec_query_stats qs 7 CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) st 8 CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp 9 order by plan_last_compiled desc
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。