_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › GetPerformanceTipsDirectlyFromSQLServer

DECLARE @StringToSearchFor VARCHAR(255) 
SET @StringToSearchFor ='%<MissingIndexes>%'
--'%<MissingIndexes>%'
--'%<ColumnsWithNoStatistics>%'
--'%<TableScan%' 
--'%CREATE PROC%MessageWrite%'

SELECT TOP 20 
st.text AS [SQL] 
, cp.cacheobjtype 
, cp.objtype 
, DB_NAME(st.dbid)AS [DatabaseName] 
, cp.usecounts AS [Plan usage] 
, qp.query_plan 
FROM sys.dm_exec_cached_plans cp 
CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st 
CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) qp 
WHERE CAST(qp.query_plan AS NVARCHAR(MAX))LIKE @StringToSearchFor 
ORDER BY cp.usecounts DESC 
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

讌蠍 覦襦 豢覦. 語企 襭襭螳 企. 磯Μ 一企. ろ レ企. 伎 リ襖 レ企. 讌蠍 覲旧 蠍磯讌 螻 語 企 覲牛伎. 蠍一 覦殊 朱 螳. 覩碁 讌蠍 螳 螻褐 . 讌蠍 蠍一 碁ロ讌 螻 語 企 碁ロ. (ろ 覩語一 <蠏碁蟾 轟 伎> 譴)