SQL Server中查询SQL语句的执行记录

SELECT TOP 1000    ST.text AS '执行的SQL语句' ,    QS.execution_count AS '执行次数' ,    QS.total_elapsed_time / 10000 AS '耗时' ,    QS.total_logical_reads AS '逻辑读取次数' ,    QS.total_logical_writes AS '逻辑写入次数' ,    QS.total_physical_reads AS '物理读取次数' ,    QS.creation_time AS '执行时间' ,    ST.*,    QS.*FROM sys.dm_exec_query_stats QSCROSS APPLY sys.dm_exec_sql_text(QS.sql_handle) STORDER BY creation_time DESC