Sql Server 查询历史执行sql语句

SELECT
creation_time,
last_execution_time,
total_logical_reads,
total_elapsed_time,
execution_count,
st.text
FROM
sys.dm_exec_query_stats AS qs
CROSS APPLY
sys.dm_exec_sql_text(qs.sql_handle) AS st
ORDER BY
last_execution_time DESC