Post reply

Blocked task

  • July 30, 2007 at 10:57 am

    #73337

    I noticed that there is a task that was blocked itself (during an insert command). Under what circumstances could this happen?

     

    Thanks,

    -R

  • July 30, 2007 at 6:34 pm

    #723443

    A task that shows up as blocking itself is usually a result of the task waiting on I/O.  Check the wait type the next time you see this occur and you should see that it is waiting on a latch or on the t-log for I/O.  This can indicate an I/O bottleneck if it becomes frequent or the process is blocking itself for a period of time.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • August 2, 2007 at 9:33 am

    #724231

    This can also happen if you are trying to do something like an insert and an update based on that insert inside of 1 transaction.

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

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