Currently running query

select 

s.session_id,

r.status,

r.blocking_session_id,

SUBSTRING(st.text,(r.statement_start_offset/2)+1,

(

(

CASE r.statement_end_offset

when  -1

THEN Datalength(st.text)

else r.statement_end_offset

END -r.statement_start_offset

)/2

)+1) AS Statment_text,

COALESCE(Quotename(DB_Name(st.dbid))+N'.'+Quotename(object_schema_name(st.objectid,st.dbid))+N'.'+

QUotename(Object_name(st.objectid,st.dbid)),'') AS Command_text,

r.wait_type,

wait_resource

,r.wait_time/(1000.0) AS WaitTimeInSec,

r.cpu_time,

r.logical_reads,

r.reads,

r.writes,

r.total_elapsed_time/(1000.0) AS Elapsedtimeinsec,

r.command,

s.login_name,

s.host_name,

s.program_name

,s.host_process_id,

s.last_request_end_time

from sys.dm_exec_sessions as s

inner join SYS.dm_exec_requests AS r

ON r.session_id = S.session_id

Cross apply sys.dm_exec_sql_text(r.sql_handle) as ST

WHERE r.session_id <>@@SPID

--and r.status like '%runn%'

ORDER BY r.cpu_time

,r.status,

r.blocking_session_id,

s.session_id