반응형 쿼리실행내역1 실행된 쿼리내역 조회 SELECT db_name(st.dbid) DBName, qs.total_elapsed_time, creation_time, last_execution_time, textFROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) AS stINNER JOIN sys.dm_exec_cached_plans AS cp ON qs.plan_handle = cp.plan_handleWHERE creation_time >= '2010-01-01 00:00:00' --AND db_name(st.dbid) is not null and cp.objtype = 'proc' --조건: 종류AND text LIKE '%delete%' O.. 2012. 10. 24. 이전 1 다음 반응형