Post reply

Process is stuck - dont know what the cause

  • August 5, 2013 at 7:27 am

    #280866

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

  • August 8, 2013 at 8:24 am

    #1639799

    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 [/url]

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

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