Handling DB Deadlocks

Locks are the reason why deadlocks occur. Locking the items and records even further down is only going to make things worse. 

 

There can only be one solution, that you review the SQL code and understand why this is happening, where are the transactions being locked. Typically, SQL Server itself prevents the locks from occurring but if they are, it means that the code is problematic. Review the code and make try to execute it into small chunks, bring it down to a smaller level; atomicity. Hopefully, that would be able to solve it.