Get running queries MSSQL

Sql code posted by cmelgarejo
created at 05 May 17:55

Edit | Back 
1
2
3
4
5
6
7
8
9
 
select 
    r.session_id,
    r.status,
    r.command,
    r.cpu_time,
    r.total_elapsed_time,
    t.text
from sys.dm_exec_requests as r
    cross apply sys.dm_exec_sql_text(r.sql_handle) as t
202 Bytes in 2 ms with coderay