쿼리시간 썸네일형 리스트형 슬로우 쿼리 slow 쿼리 확인 방법. 간략.. 샘플. 1초 이상 쿼리만 조회. select top 100 t.text, q.*from ( select (total_elapsed_time / execution_count) / 1000000 as AvgDuration, * from sys.dm_exec_query_stats where (total_elapsed_time / execution_count) > 1000000 -- 1 sec) as qcross apply sys.dm_exec_sql_text(sql_handle) as torder by AvgDuration desc ----------------------------------- select top 10 * from sys.sysprocesseswhere b.. 더보기 이전 1 다음