检测重编译 SELECT TOP 10qs.plan_generation_num,qs.execution_count,DB_NAME(st.dbid) AS DbName,st.objectid,st.TEXTFROM sys.dm_exec_query_stats qsCROSS APPLY sys.dm_exec_sql_text(sql_handle) AS stORDER BY plan_generation_num DESC