SQL Server Plan Cache

 SQL Server Plan Cache 執行計畫Cache

清除SQL Server所有執行計畫Cache

DBCC FREEPROCCACHE;

清除SQL Server所有ad hoc and prepared plan cache

DBCC FREESYSTEMCACHE ('SQL Plans');

清除指定DB的所有執行計畫Cache

DBCC FLUSHPROCINDB (DB_ID);

SELECT OBJECT_NAME (st.objectid),st.[text],cp.plan_handle, cp.objtype, cp.usecounts, 

DB_NAME(st.dbid) AS [DatabaseName]

FROM sys.dm_exec_cached_plans AS cp CROSS APPLY sys.dm_exec_sql_text(plan_handle) AS st 

--WHERE OBJECT_NAME (st.objectid)

WHERE DB_NAME(st.dbid) = N'PMISRKM01' and

st.[text]

LIKE N'%搜尋字串%' Order by usecounts  OPTION (RECOMPILE); 

清除指定的執行計畫Cache

--DBCC FREEPROCCACHE (0x06000500612DD31EB0B82EFA1302000001000000000000000000000000000000000000000000000000000000)