查询sqlserver正在执行的语句 无 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.s
查询sql server正在执行的语句
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_timefrom sys.dm_exec_requests erinner join sys.sysprocesses sp on er.session_id = sp.spidcross apply sys.dm_exec_sql_text(er.sql_handle) as qtwhere session_id > 50 /* ignore system spids.*/ and session_id not in (@@spid)