SQL Server 查詢歷史執行的SQL語句

user DB --在對應資料查詢

go

SELECT st.text as sql_statement,

       qs.creation_time as plan_last_compiled,

       qs.last_execution_time as plan_last_executed,

       qs.execution_count as plan_executed_count,

       qp.query_plan

FROM sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(qs.plan_handle) st

CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp

where convert(nvarchar(10),last_execution_time,120)='2020-11-30' --查詢日期

and st.text like '%定義遊標%'--自定義查詢條件

order by total_elapsed_time/execution_count desc