sql server性能分析--查看当前执行的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_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,
          2