Transactions

Avoid the use of SQL transactions. If required, make the SQL transaction as short as possible. SQL transactions help to ensure database integrity by performing all the actions at once. As such, if the required lock cannot be acquired, the whole processes stops until it’s released. This is a leading cause of blocking.