The problem was my application is massively running a stored procedure that was quite large and then I optimized it a lot, now everything is working fine.

Thank you all for...

Thanks for your replies again.

I resolved the blocking problem by making a primary key field for both tables used and using only that field's value in the update string.

Now there...

Thank you all very much for your replies, they have been very helpful.

I have figured the source of problems to be this huge command that is executed 4 times after...

Is there any way I could see some data of each blocked processes like query string or at least which table its supposed to be updating?

Thanks.

Hi. Thanks for your reply.

The query came back with 110 rows.

Here is the results file:

http://elpokarin.com/result.csv