Our client is using NAV 2013 and experiencing deadlocks.
We have been able to reproduce the issue with 7 users doing the same activity. The issue was resolved by putting an explicit lock on one table. However when the changes were deployed on Prod, it backfired as the other activities were not having the same locking sequence.
Now we are working on breaking a big transaction into smaller one so that we can reduce the transaction time and deadlocks.
I am still worried that this will not resolve the issue entirely unless we correct the Table Locking Order.
Until version 2009 R2, we had Client Monitor in classic client and there was a "Database Resource Toolkit" available which was very useful to identify the locking order. I am unable to find any tool in 2013 which can tell me the transactions in an activity and the Table locking order for all the tables involved in the transaction.
I was hoping if somebody can help me with the approach to resolve deadlock in version NAV 2013.