sqlserver中查询时间段执行sql语句记录

declare @startTime datetime,@endTime datetime;
set @startTime='2021-7-6 00:00:00';
set @endTime='2021-7-7 00:00:00';
 
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 @startTime AND @endTime
AND ST.text LIKE '%delete%'
AND ST.text not LIKE '%isdelete%'
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 @startTime AND @endTime
--AND ST.text NOT LIKE 'select%' 
AND ST.text  LIKE 'delete%' 
AND ST.text NOT LIKE 'isdelete%' 
ORDER BY QS.creation_time DESC

说明： ST.text 为筛选字段条件