sql执行历史

  1. select TOP 1000 *from (SELECT
    --创建时间
    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
    FROM
    sys.dm_exec_query_stats QS
    --关键字
    CROSS APPLY
    sys.dm_exec_sql_text(QS.sql_handle) ST ) as aa where aa.statement_text like'%delete from ExitStripProcess%'
    and
    aa.creation_time between '2017-11-01 08:37:16.983' and'2017-11-04 08:37:16.983'

posted @ 2017-11-10 11:12  步狰  阅读(438)  评论(0)    收藏  举报