수

mssql에서 쿼리 로그 보기

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

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-09-19 조회 3,740
14-09-19 조회 3,992
14-09-19 조회 4,377
14-09-19 조회 4,016
14-09-19 조회 4,477
14-09-19 조회 3,934
14-09-19 조회 4,115
14-09-19 조회 4,227
14-09-19 조회 3,967
14-09-19 조회 4,015
14-09-19 조회 4,089
14-09-19 조회 5,044
14-09-19 조회 3,989
14-09-18 조회 4,061
14-09-18 조회 3,923
14-09-18 조회 4,189
14-09-18 조회 4,016
14-09-18 조회 3,711
14-09-18 조회 4,290
14-09-18 조회 4,614
14-09-18 조회 4,272
14-09-18 조회 4,115
14-09-18 조회 4,266
14-09-18 조회 4,973
14-09-18 조회 4,135
14-09-18 조회 4,101
14-09-18 조회 5,498
14-09-18 조회 5,401
14-09-18 조회 4,218
14-09-18 조회 4,716
14-09-18 조회 4,329
14-09-18 조회 4,114
14-09-18 조회 4,310
14-09-18 조회 4,919
14-09-17 조회 4,082
14-09-16 조회 4,882
14-09-16 조회 5,104
14-09-16 조회 3,807
14-09-15 조회 4,015
14-09-15 조회 3,580
14-09-13 조회 4,666
14-09-12 조회 4,477
14-09-12 조회 3,856
14-09-12 조회 3,753
14-09-11 조회 3,477
14-09-11 조회 4,297
14-09-11 조회 4,570
14-09-10 조회 3,403
14-09-10 조회 3,585
14-09-03 조회 3,810
14-09-03 조회 3,744
14-09-03 조회 3,999
14-09-03 조회 5,675
14-09-01 조회 5,423
14-09-01 조회 4,857
14-09-01 조회 4,293
14-08-30 조회 4,313
14-08-30 조회 5,579
14-08-29 조회 4,539
14-08-28 조회 5,975
14-08-28 조회 6,618
14-08-28 조회 6,866
14-08-27 조회 6,893
14-08-27 조회 7,053
14-08-27 조회 5,555
14-08-27 조회 2만
14-08-27 조회 4,224
14-08-26 조회 4,258
14-08-26 조회 4,178
14-08-26 조회 4,060
14-08-26 조회 4,017
14-08-26 조회 3,841
14-08-26 조회 3,708
14-08-26 조회 4,347
14-08-26 조회 4,033
14-08-26 조회 3,961
14-08-26 조회 4,151
14-08-26 조회 3,985
14-08-26 조회 3,827
14-08-26 조회 4,040
14-08-26 조회 4,133
14-08-26 조회 4,130
14-08-26 조회 3,994
14-08-26 조회 3,877
14-08-26 조회 3,843
14-08-26 조회 4,120
14-08-26 조회 3,729
14-08-26 조회 3,877
14-08-26 조회 3,656
14-08-26 조회 3,501
14-08-26 조회 3,800
14-08-26 조회 4,403
14-08-26 조회 3,676
14-08-26 조회 3,823
14-08-26 조회 3,768
14-08-26 조회 3,615
14-08-26 조회 3,774
14-08-26 조회 3,691
14-08-26 조회 3,919
14-08-26 조회 4,406