Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_whoisactive shows a SP is running for more than 2 days......<!-- 864 --> Expand / Collapse
Author
Message
Posted Thursday, August 21, 2014 6:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 21, 2015 12:45 PM
Points: 209, Visits: 790
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?
Post #1605784
Posted Thursday, August 21, 2014 1:38 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 21, 2015 12:45 PM
Points: 209, Visits: 790
Anyone please?
Post #1605986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse