---

?

SELECT TOP 30000total_worker_time/1000 AS [總消耗CPU 時間(ms)],execution_count [運行次數],qs.total_worker_time/qs.execution_count/1000 AS [平均消耗CPU 時間(ms)],last_execution_time AS [最后一次執行時間],min_worker_time /1000 AS [最小執行時間(ms)],max_worker_time /1000 AS [最大執行時間(ms)],SUBSTRING(qt.text,qs.statement_start_offset/2+1,(CASE WHEN qs.statement_end_offset = -1THEN DATALENGTH(qt.text)ELSE qs.statement_end_offset END -qs.statement_start_offset)/2 + 1)AS [使用CPU的語法], qt.text [完整語法],qt.dbid, dbname=db_name(qt.dbid),qt.objectid,object_name(qt.objectid,qt.dbid) ObjectName FROM sys.dm_exec_query_stats qs WITH(nolock) CROSS apply sys.dm_exec_sql_text(qs.sql_handle) AS qt WHERE execution_count>1 and qs.creation_time BETWEEN '2017-11-13 20:10:00' AND '2017-11-13 20:15:00' ORDER BY (qs.total_worker_time/qs.execution_count/1000) DESC

?

SELECT TOP 1000 ST.text AS '執行的SQL語句',QS.execution_count AS '執行次數',QS.total_elapsed_time AS '耗時',QS.total_logical_reads AS '邏輯讀取次數',QS.total_logical_writes AS '邏輯寫入次數',QS.total_physical_reads AS '物理讀取次數', QS.creation_time AS '執行時間' , QS.* FROM sys.dm_exec_query_stats QSCROSS APPLY sys.dm_exec_sql_text(QS.sql_handle) ST WHERE QS.creation_time BETWEEN '2015-08-01 00:00:00' AND '2015-09-02 11:00:00' ORDER BYQS.total_elapsed_time DESC

?

轉載于:https://www.cnblogs.com/m0488/p/9442063.html

總結

以上是生活随笔為你收集整理的SQLSERVER 执行过的语句查询的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。