SELECT session_id, host_process_id FROM sys.dm_exec_sessions WHERE session_id = XXX