查看SQL SERVER 数据库正在执行的语句和时长等

最新推荐文章于 2024-07-11 02:06:43 发布

-_-哈-_-哈-_-哈-_-

最新推荐文章于 2024-07-11 02:06:43 发布

阅读量1.7k

点赞数 1

本文链接：https://blog.csdn.net/fzgjf08/article/details/54580042

版权

SELECT session_Id,
--ecid,
--sp.dbid,
--DB_NAME(sp.dbid) as DB_NM,
--nt_username,
er.status,
wait_type,
SUBSTRING (qt.text, er.statement_start_offset/2,
(CASE WHEN er.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
ELSE er.statement_end_offset END - er.statement_start_offset)/2) as CurrentSQL,
qt.text,
--program_name,
--Hostname,
start_time,
DATEDIFF ( millisecond,start_time, GETDATE() ) AS execTime
FROM sys.dm_exec_requests er
INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid
CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt
WHERE session_Id > 50
AND session_Id NOT IN (@@SPID)
--and sp.dbid=7
ORDER BY DATEDIFF ( millisecond,start_time, GETDATE() ) desc