Querying SQL records that SQL Server has executed

SELECT TOP +--Create Time Qs.creation_time,--Query Statement SUBSTRING (St.text, (Qs.statement_start_offset/2)+1, (case Qs.statement_end_offset when-1Then datalength (st.text) ELSE Qs.statement_end_offset End-Qs.statement_start_offset)/2) +1) as Statement_text,--executes the text st.text,--Execution Plan Qs.total_worker_time, Qs.last_worker_time, Qs.max_worker_time, qs.min_worker_time from Sys.dm_exec_query_ Stats QS--keyword Cross APPLY sys.dm_exec_sql_text (qs.sql_handle) ST WHERE qs.creation_time between'2018-05-08 09:00:00'and'2018-05-08 18:00:00'--and St.text like'%%'ORDER by Qs.creation_time descselect TOP +--Create Time Qs.creation_time,--Execute text st.textfrom sys.dm_exec_query_stats QS--keyword Cross APPLY sys.dm_exec_sql_text (qs.sql_handle) ST WHERE qs.creation_time between'2018-05-08 09:00:00'and'2018-05-08 18:00:00'and St.text not like'%select * from T_locationinfo WHERE strcliplogicid in (%'ORDER by Qs.creation_time DESC

Http://www.cnblogs.com/yunfeifei/p/3866275.html

Querying SQL records that SQL Server has executed