日志

分享正在执行的10个运行时间最长的查询语句.: 2011-11-14 15:54; 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; 354 次阅读|1 个评论热度 1

33来迟

GMT+8, 2024-5-10 05:19 , Processed in 0.015844 second(s), 6 queries , Gzip On, Redis On.