Determining why the deadlock occurred
Identifying the SQL statements and the resources involved in the deadlock, and finding the access path will typically show you why the deadlock occurred. Knowledge of why the deadlock occurred can help you to develop a solution. However; this process can be time-consuming.