SELECT s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name, s.status AS session_status,
    db_name(er.database_id) AS database_name,
    er.status AS request_status, er.command, er.percent_complete,
    er.blocking_session_id,
    er.wait_type, er.wait_time / 1000.0 AS wait_sec, er.last_wait_type, er.wait_resource,
    er.transaction_id, er.open_transaction_count,
    er.cpu_time / 1000.0 AS cpu_sec, er.total_elapsed_time / 1000.0 AS total_elapsed_sec, er.start_time, er.reads, er.writes, er.logical_reads,
    er.sql_handle, er.plan_handle
  FROM sys.dm_exec_requests er
    INNER JOIN sys.dm_exec_sessions s ON er.session_id = s.session_id
  WHERE s.is_user_process = 1
    AND s.session_id <> @@SPID