You can try the following code for the queries that are running:

select s.session_id, s.status, command, text, query_plan

from

sys.dm_exec_requests r

join...