sqlserver 查询语句执行历史
SELECT TOP 1000 -----创建时间 QS.creation_time, ----查询语句 SUBSTRING(ST.text,(QS.statement_start_offset/2)+1, ((CASE QS.statement_end_offset WHEN -1 THEN DATALENGTH(st.text) ELSE QS.statement_end_offset END - QS.statement_start_offset)/2) + 1 ) AS statement_text, ----执行文本 ST.text ----执行计划 --QS.total_worker_time, --QS.last_worker_time, --QS.max_worker_time, --QS.min_worker_time FROM sys.dm_exec_query_stats QS ----关键字 CROSS APPLY sys.dm_exec_sql_text(QS.sql_handle) ST WHERE QS.creation_time BETWEEN '2019-04-14 00:00:00' AND '2019-04-14 23:00:00' ----AND ST.text LIKE ‘%%' ORDER BY QS.creation_time DESC SELECT TOP 1000 --创建时间 QS.creation_time, --执行文本 ST.text FROM sys.dm_exec_query_stats QS --关键字 CROSS APPLY sys.dm_exec_sql_text(QS.sql_handle) ST WHERE QS.creation_time BETWEEN '2019-04-14 00:00:00' AND '2019-04-14 23:00:00' AND ST.text NOT LIKE '%update dyhramember%' ORDER BY QS.creation_time DESC