If multiple different services send INSERT queries for the same table simultaneously to SQL Server, using their own connections, how many INSERTS can be committed by SQL Server in parallel? Or SQL Server can only process them sequentially?

CodePudding user response：

You can have up to

You can see that IX lock on the same PAGE of the first transaction is not blocking the IX on the page of the other one:

In theory the inserts are not blocking each other and can be executed at the same time.