SELECT TOP 1000 creation_time dd, 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 creation_time DESC;
mssql에서 쿼리 로그 보기
http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=tipntech&wr_id=78519
http://m.blog.daum.net/partsofmemory/43
http://nexondbteam.tistory.com/70
insert 문을 찾으면 대충 알수 있을듯 합니다.
SELECT TOP 1000 creation_time dd, 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 creation_time DESC;