SYSK 338: What SQL Queries Are Currently Running?

  • Article

That’s easy -- just run the SQL statement below…

 

select session_id, request_id, start_time, status, cpu_time, er.total_elapsed_time,

      substring(st.text,

      (er.statement_start_offset/2) + 1,

      ((case er.statement_end_offset when -1 then datalength(st.text) else er.statement_end_offset end

      - er.statement_start_offset)/2) + 1) as query

from sys.dm_exec_requests er

cross apply sys.dm_exec_sql_text(er.sql_handle) st