extrobe
1/31/2017 - 2:12 PM

Currently Executing Queries

Currently Executing Queries

select  T.text, R.Status, R.Command, DatabaseName = db_name(R.database_id) 
        , R.cpu_time, R.total_elapsed_time, R.percent_complete 
from    sys.dm_exec_requests R 
        cross apply sys.dm_exec_sql_text(R.sql_handle) T