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, QS.*
FROM sys.dm_exec_query_stats QS
--关键字
CROSS APPLY sys.dm_exec_sql_text(QS.sql_handle) ST
WHERE QS.creation_time BETWEEN '2023-01-28 09:00:00' AND '2023-01-28 11:00:00'
--AND ST.text LIKE '%%'
ORDER BY QS.creation_time DESC;
转载
https://blog.csdn.net/weixin_30716141/article/details/99050090