日志
正在执行的10个运行时间最长的查询语句.
热度 1
select top 10 substring(text,(statement_start_offset/2)+1,((case statement_end_offset when -1 then datalength(text) else statement_end_offset end - statement_start_offset)/2)+1) as query_text,*
from sys.dm_exec_requests
cross apply sys.dm_exec_sql_text(sql_handle)
order by total_elapsed_time desc
from sys.dm_exec_requests
cross apply sys.dm_exec_sql_text(sql_handle)
order by total_elapsed_time desc
51072502110008