SELECT
R.session_id
,DB_NAME(R.database_id) AS DatabaseName
,S.original_login_name AS LoginName
,S.host_name AS ClientMachine
,S.program_name AS ApplicationName
,R.start_time AS RequestStartTime
,ST.text AS SQLQuery
,QP.query_plan AS ExecutionPlan
,R.cpu_time AS CPUTime
,R.total_elapsed_time AS TotalTimeElapsed
,R.open_transaction_count AS TotalTransactionsOpened
,R.reads
,R.logical_reads
,R.writes AS TotalWrites
,CASE
WHEN R.wait_type IS NULL THEN 'Request Not Blocked'
ELSE 'Request Blocked'
END AS QueryBlockInfo
,blocking_session_id AS RequestBlockedBy
FROM sys.dm_exec_requests AS R
INNER JOIN sys.dm_exec_sessions AS S
ON R.session_id = S.session_id
CROSS APPLY sys.dm_exec_sql_text(R.sql_handle) AS ST
CROSS APPLY sys.dm_exec_query_plan (R.plan_handle) AS QP
ORDER BY TotalTimeElapsed DESC