sp_whoisactive shows a SP is 'sleeping' for more than 2 days with session id = 90. But when I run sys.dm_exec_request it doesn't show any spid 90, i think because it is not in 'running' status. I tried sys.sysprocess but don't see anything the spid is in 'sleeping' status. Does anyone knows what's happening here plz?