查询CPU耗时
SELECT TOP 50
DB_NAME
(dbid
) AS DBNAME
,
OBJECT_NAME
(objectid
,dbid
) as OBJECTNAME
,
total_worker_time
/execution_count
/1000/1000 AS [CPU平均执行
(秒
)],
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) N
'执行语句'
,st
.text N
'完整语句'
,total_worker_time
/1000/1000 AS [总消耗CPU 时间
(秒
)]
,execution_count
[运行次数
]
,qs
.total_worker_time
/qs
.execution_count
/1000/1000 AS [平均执行CPU 时间
(秒
)]
,last_execution_time
AS [最后一次执行时间
]
,max_worker_time
/1000/1000 AS [最大执行时间
(秒
)]
,total_physical_reads N
'物理读取总次数'
,total_logical_reads
/execution_count N
'每次逻辑读次数'
,total_logical_reads N
'逻辑读取总次数'
,total_logical_writes N
'逻辑写入总次数'
,*
FROM sys
.dm_exec_query_stats
AS qs
CROSS APPLY sys
.dm_exec_sql_text
(qs
.sql_handle
) AS st
WHERE last_execution_time
> dateadd
(minute,-100,getdate
())
ORDER BY total_worker_time
/execution_count
DESC;
GO
转载请注明原文地址: https://mac.8miu.com/read-490127.html