SELECT s.session_id,

       r.start_time,

       r.total_elapsed_time/1000 AS   elapsed_seconds,

       r.status AS RequestStatus,

       r.database_id,

       DB_NAME(r.database_id) AS   DatabaseName,

       r.reads,

       r.writes,

       r.logical_reads,

       r.cpu_time,

       r.total_elapsed_time,

       s.status AS SessionStatus,

       qt.event_info as text,

       getdate() createtime

    FROM sys.dm_exec_requests(nolock) r

 INNER JOIN sys.dm_exec_sessions(nolock) s

      ON r.session_id = s.session_id

    LEFT JOIN sys.dm_exec_connections(nolock) c

      ON c.session_id = s.session_id

 cross apply sys.dm_exec_input_buffer   (s.session_id, 0) as qt

 WHERE DB_NAME(r.database_id)<>'master'

and qt.event_info is not null

 order by r.cpu_time desc