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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, September 7, 2014 5:20 PM
Points: 100, Visits: 356
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-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, September 7, 2014 5:20 PM
Points: 100, Visits: 356
Anyone please?
Post #1605986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse