//查询目前系统正在运行的sql 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     AND session_Id NOT IN (@@SPID)