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

Process is stuck - dont know what the cause Expand / Collapse
Author
Message
Posted Monday, August 5, 2013 7:27 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 9:21 AM
Points: 88, Visits: 199
The Process is running. I can see it under Activity Monitor with following details.
Application : APS
Command : INSERT
Status : Runnable

It is suppose to finish in less than 5 minits but its stuck for hours now. Is there a way to find out what's causing it not running ( or waiting ) ?

Post #1480906
Posted Thursday, August 8, 2013 8:24 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 7, 2013 6:50 AM
Points: 11, Visits: 24
Activity Monitor usually tells you what resource it is waiting for. For example another process maybe trying to do massive select or update on the same tables.

please use free productivity tool for SSMS - SQL Hunting Dog
Post #1482360
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse