وب سایت سید حامد واحدی | Seyedhamed Vahedi Website

Query Plan of Stored Procedure


SELECT OBJECT_NAME(st.objectid,st.dbid) AS ObjectName, cp.usecounts AS ExecutionCount, st.TEXT AS QueryText, qp.query_plan AS QueryPlan
FROM sys.dm_exec_cached_plans AS cp
      CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) AS qp
      CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st
WHERE cp.objtype = 'Proc' AND OBJECT_NAME(st.objectid,st.dbid) = 'StoredProcedure-Name';
Seyed Hamed Vahedi Seyed Hamed Vahedi     Sun, 1 July, 2018