Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Monday, August 5, 2013 7:27 AM


Group: General Forum Members
Last Login: Thursday, May 5, 2016 5:20 AM
Points: 114, Visits: 265
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



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