Insert statement on one table blocking delete on another unrelated table on sql server

by ROHIT IHARE   Last Updated April 20, 2018 10:06 AM

I performed a load testing on our environment,where for eg. stored procedure say "sp" was called multiple times to process on different set of ids.

During load testing this store procedure encountered multiple blocking over single record situated in table say "A"

Out of all these blocking, first blocking was occurred while the proc was deleting some records from table A in one session and blocker script was trying to insert few records in table B in another session.

But table A and B does not have any relation between them (no foreign key over each other and no triggers) Although they have primary key which is a foreign key on some other common table. But I think that should not be the issue.

the mentioned blocking has wait type : LCK_M_U

I could not figure out the exact reason, which is causing the blocking.



Related Questions



Postgres: SELECT blocks INSERT for an unrelated table

Updated December 14, 2017 09:06 AM

SQL Blocking causing timeouts

Updated May 14, 2015 05:02 AM


Blocking SPID has Zero Disk IO and Zero CPU Time

Updated April 11, 2018 14:06 PM