查看正在执行的sql语句
时间：2021-07-01 10:21:17
帮助过：2人阅读
t
AS(
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)
)
SELECT * FROM t
--WHERE [Individual Query] LIKE ‘%Proc_TEST%‘--自己改
查看正在执行的sql语句
标签：
