sql server 查询历史执行的sql情况

select *from (
SELECT qs.creation_time AS ExecutionTime,
       SUBSTRING(qt.text, (qs.statement_start_offset/2)+1, ((CASE WHEN qs.statement_end_offset = -1 THEN DATALENGTH(qt.text) ELSE qs.statement_end_offset END-qs.statement_start_offset)/2)) AS QueryText,
       qp.query_plan AS ExecutionPlan
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) AS qp
)A
where 
 ---QueryText like '%ods%' and 
 ExecutionTime >= '2024-01-24'
order by ExecutionTime desc