Would the query below work?

I'm looking for long-running queries that are currently running on the server, not a historic analysis of those stored in the cache.

Queries are ordered by total_elapsed_time desc:

SELECT

r.session_id

,r.start_time

,TotalElapsedTime_ms = r.total_elapsed_time

,r.[status]

,r.command

,DatabaseName = DB_Name(r.database_id)

,r.wait_type

,r.last_wait_type

,r.wait_resource

,r.cpu_time

,r.reads

,r.writes

,r.logical_reads

,t.[text] AS [executing batch]

,SUBSTRING(

t.[text], r.statement_start_offset / 2,

(CASE WHEN r.statement_end_offset = -1 THEN DATALENGTH (t.[text])

ELSE r.statement_end_offset

END - r.statement_start_offset ) / 2

) AS [executing statement]

,p.query_plan

FROM

sys.dm_exec_requests r

CROSS APPLY

sys.dm_exec_sql_text(r.sql_handle) AS t

CROSS APPLY

sys.dm_exec_query_plan(r.plan_handle) AS p

ORDER BY

r.total_elapsed_time DESC;