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

posted @   芒果5s  阅读(321)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示