Post reply

How to deal with random block?

  • January 30, 2012 at 8:56 am

    #267349

    I have a third-party application that causes a block occasionally. The vendor is not able (capable) of fixing the code.

    The strange thing is the application is attempting to insert a row into an empty table. The insert statement is full of NULL values for nearly every field.

    I have to manually kill the process.

    I am looking for suggestions on how to deal with this this, any suggestions?

    Thanks for you time,

    Travis

  • January 30, 2012 at 10:06 am

    #1440119

    Can you check what is the wait type when the INSERT query is running? If the application guys can not change the code then you need to figure out how to make the query run faster. For this look at the query and see what is it waiting on.

    Blog
    http://saveadba.blogspot.com/

  • January 30, 2012 at 1:05 pm

    #1440206

    There is nothing in the Wait Type field when I view the block through Activity Monitor.

    Not sure how to speed up the query though.

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

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