select er.session_id, blocking_session_id, wait_type
    , wait_time, last_wait_type, database_id
    , user_id, er.cpu_time, er.reads + er.writes AS Physical_IO, granted_query_memory
    , es.login_time, es.last_request_start_time, es.host_name
    , program_name, nt_domain, nt_user_name, login_name 
 from sys.dm_exec_requests ER
	INNER JOIN sys.dm_exec_sessions ES
		ON ER.session_id = ES.session_id
 where blocking_session_id <> 0 
 or ER.session_id in (select blocking_session_id from sys.dm_exec_requests)