sp_whoisactive shows a SP is running for more than 2 days......<!-- 864 -->

  • 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?

  • Anyone please?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply