Hi, I have an appliction which run the following two SQLs in the order:
1.INSERT INTO tab1 WITH (ROWLOCK)
2.DELETE from tab1 WITH (ROWLOCK)
This appliction is executed by hundreds of users at the same time. Normally these SQLs only takes less than 1 seoncd. Sometimes I saw significantly delay on these SQLs - around 10 seconds. It seems that they are blocking each other (when updating clustered index?), is there a way to solve this conflict?