SELECT
[Spid] = session_id,
ecid,
[Database] = DB_NAME( sp.dbid ),
[User] = nt_username,
[Status] = er.status ,
[Wait] = wait_type,
[Individual Query] = 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
),
[Parent Query] = qt.text ,
Program = program_name,
hostname,
nt_domain,
start_time
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 -- Ignore system spids.
AND session_id NOT IN ( @@SPID ) -- Ignore this current statement.
ORDER BY 1
SQL SERVER查看当前有哪些正在执行的SQL
最新推荐文章于 2024-06-30 21:16:43 发布