속더 저하1 [MS-SQL] 실행계획 확인 / 속도 저하 SELECT cp.refcounts ,cp.usecounts ,cp.objtype ,st.dbid ,st.objectid ,st.text ,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 2016. 1. 12. 이전 1 다음