수

mssql에서 쿼리 로그 보기

· 2014-08-01 (금) 12:50:29 · 8849

SELECT TOP 100 creation_time, last_execution_time, total_clr_time, 

    total_clr_time/execution_count AS [Avg CLR Time], last_clr_time, 

    execution_count,  

    SUBSTRING(st.TEXT, (qs.statement_start_offset/2) + 1, 

    ((CASE statement_end_offset  

        WHEN -1 THEN DATALENGTH(st.TEXT) 

        ELSE qs.statement_end_offset END  

            - qs.statement_start_offset)/2) + 1) AS statement_text 

FROM sys.dm_exec_query_stats AS qs 

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st 

ORDER BY total_clr_time/execution_count DESC; 

 

출처 : http://superad.tistory.com/295 

댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
14-10-25 조회 5,202
14-10-25 조회 6,394
14-10-25 조회 3,807
14-10-25 조회 3,956
14-10-24 조회 3,916
14-10-23 조회 4,528
14-10-22 조회 3,675
14-10-22 조회 4,346
14-10-22 조회 7,195
14-10-22 조회 4,900
14-10-22 조회 4,851
14-10-22 조회 9,013
14-10-19 조회 4,761
14-10-18 조회 5,741
14-10-17 조회 5,252
14-10-17 조회 4,037
14-10-17 조회 6,118
14-10-17 조회 5,506
14-10-17 조회 9,032
14-10-17 조회 6,510
14-10-17 조회 4,807
14-10-17 조회 5,124
14-10-14 조회 3,352
14-10-14 조회 4,267
14-10-13 조회 3,831
14-10-13 조회 6,508
14-10-13 조회 4,449
14-10-13 조회 4,337
14-10-13 조회 4,542
14-10-11 조회 6,708
14-10-11 조회 6,622
14-10-11 조회 6,500
14-10-10 조회 4,009
14-10-10 조회 6,467
14-10-10 조회 5,742
14-10-10 조회 6,325
14-10-10 조회 3,568
14-10-10 조회 5,484
14-10-10 조회 5,489
14-10-10 조회 5,571
14-10-10 조회 4,486
14-10-10 조회 4,972
14-10-10 조회 4,277
14-10-10 조회 4,125
14-10-08 조회 4,650
14-10-08 조회 3,770
14-10-08 조회 6,985
14-10-07 조회 6,204
14-10-07 조회 4,528
14-10-07 조회 5,554
14-10-07 조회 3,741
14-10-07 조회 4,728
14-10-07 조회 6,403
14-10-06 조회 6,758
14-10-06 조회 7,539
14-10-05 조회 3,746
14-10-04 조회 5,015
14-10-03 조회 6,334
14-10-02 조회 3,918
14-09-29 조회 4,109
14-09-29 조회 4,568
14-09-28 조회 3,887
14-09-27 조회 5,230
14-09-27 조회 4,690
14-09-26 조회 6,774
14-09-26 조회 5,205
14-09-25 조회 7,547
14-09-25 조회 4,057
14-09-25 조회 4,062
14-09-24 조회 4,859
14-09-24 조회 4,821
14-09-24 조회 4,310
14-09-24 조회 3,881
14-09-24 조회 4,503
14-09-24 조회 3,966
14-09-23 조회 4,146
14-09-23 조회 4,260
14-09-23 조회 4,041
14-09-22 조회 3,918
14-09-22 조회 4,846
14-09-22 조회 4,954
14-09-22 조회 6,174
14-09-22 조회 4,136
14-09-22 조회 3,814
14-09-22 조회 3,880
14-09-21 조회 5,831
14-09-21 조회 4,608
14-09-21 조회 4,443
14-09-21 조회 3,923
14-09-21 조회 4,480
14-09-21 조회 4,367
14-09-21 조회 4,036
14-09-20 조회 4,025
14-09-20 조회 3,938
14-09-20 조회 3,835
14-09-20 조회 4,565
14-09-20 조회 4,014
14-09-19 조회 3,931
14-09-19 조회 4,095
14-09-19 조회 4,300