[MSSQL]執行計劃

--清除資料庫執行計劃cache

use 資料庫

alter database scoped configuration clear procedure_cache

--查詢執行計劃cache

select cap.usecounts as '使用次數'

      ,cap.cacheobjtype as '快取類型'

  ,objtype as '物件類型'

  ,st.text

from sys.dm_exec_cached_plans cap

CROSS APPLY sys.dm_exec_sql_text(plan_handle) as st

where st.text not like '%sys%'

  and st.text like '%myparatest%'

go