Post reply

DELETE operation immediately in SUSPENDED mode

  • August 22, 2012 at 8:06 am

    #280642

    Hi

    when I try to delete rows from a table, it will immediately show as 'SUSPENDED' when checked with sp_who2. Nothing is happening I guess...and no SPIDS are listed in the BlkBy column either..

    I already restarted the MSSql service and the same happens.

    Any suggestions?

    ville

  • August 22, 2012 at 8:12 am

    #1528658

    Suspended means it's waiting for something. Check what it's waiting for (wait type, wait resource in sys.dm_exec_requests), it doesn't have to be a lock.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 22, 2012 at 8:22 am

    #1528670

    Hi,

    the wait_type is 'PAGEIOLATCH_EX' and the reads, writes, logical_reads are changing all the time...

    so does this meant that it is actually deleting but it just takes a long time...?

    v

  • August 22, 2012 at 8:27 am

    #1528674

    Yes, it's deleting. The PageIOLatch indicates that the waits are due to fetching the pages off disk.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 22, 2012 at 8:29 am

    #1528675

    OK,

    thank you for the info. I'll just let it run then and hope it finishes in time before the normal JOB routines start

    ville

Viewing 5 posts - 1 through 4 (of 4 total)

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