수

mssql에서 쿼리 로그 보기

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

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-08-01 조회 3,872
14-07-31 조회 3,959
14-07-31 조회 4,822
14-07-30 조회 4,499
14-07-30 조회 4,305
14-07-30 조회 4,056
14-07-30 조회 4,131
14-07-29 조회 6,610
14-07-29 조회 4,466
14-07-28 조회 4,824
14-07-27 조회 5,066
14-07-27 조회 4,243
14-07-26 조회 4,106
14-07-26 조회 4,104
14-07-25 조회 3,551
14-07-25 조회 4,118
14-07-25 조회 4,630
14-07-23 조회 4,573
14-07-23 조회 3,751
14-07-22 조회 4,192
14-07-21 조회 3,695
14-07-21 조회 4,712
14-07-19 조회 4,068
14-07-18 조회 3,439
14-07-18 조회 5,206
14-07-17 조회 9,533
14-07-17 조회 4,164
14-07-17 조회 3,824
14-07-16 조회 4,026
14-07-16 조회 3,584
14-07-16 조회 4,118
14-07-15 조회 3,666
14-07-14 조회 6,247
14-07-13 조회 4,111
14-07-12 조회 4,514
14-07-12 조회 3,899
14-07-11 조회 5,340
14-07-10 조회 4,228
14-07-09 조회 5,629
14-07-08 조회 4,872
14-07-08 조회 5,537
14-07-08 조회 4,336
14-07-08 조회 5,504
14-07-06 조회 4,503
14-07-06 조회 3,864
14-07-05 조회 4,127
14-07-04 조회 8,506
14-07-04 조회 4,013
14-07-04 조회 3,527
14-07-04 조회 3,697
14-07-03 조회 3,845
14-07-03 조회 4,231
14-07-03 조회 4,676
14-07-02 조회 5,036
14-07-02 조회 3,926
14-07-02 조회 4,184
14-07-01 조회 3,948
14-07-01 조회 3,539
14-06-28 조회 5,187
14-06-28 조회 4,467
14-06-28 조회 6,221
14-06-27 조회 3,982
14-06-27 조회 3,838
14-06-27 조회 4,886
14-06-27 조회 5,546
14-06-26 조회 4,952
14-06-26 조회 6,116
14-06-26 조회 4,423
14-06-26 조회 6,494
14-06-26 조회 3,636
14-06-25 조회 3,924
14-06-24 조회 5,362
14-06-24 조회 3,975
14-06-24 조회 5,987
14-06-24 조회 6,131
14-06-24 조회 4,372
14-06-24 조회 5,074
14-06-20 조회 4,143
14-06-20 조회 4,443
14-06-20 조회 3,948
14-06-19 조회 5,160
14-06-18 조회 4,984
14-06-18 조회 4,114
14-06-18 조회 8,446
14-06-12 조회 5,598
14-06-12 조회 6,246
14-06-11 조회 5,135
14-06-10 조회 4,057
14-06-06 조회 5,614
14-06-05 조회 5,483
14-06-04 조회 5,077
14-05-29 조회 4,828
14-05-28 조회 3,973
14-05-27 조회 4,997
14-05-26 조회 5,510
14-05-26 조회 4,305
14-05-23 조회 5,733
14-05-21 조회 4,626
14-05-19 조회 7,583
14-05-18 조회 5,005