I have some locking problems with a NAV 5 database. A lot of Clients (about 40 to 60) and 5 NAS are connected to the database. Since few days from time to time the users can not work because the table "Sales Shipment Header" is locked (sometimes other tables also affected but most of the time it is table 110). The fastest way to remove the locking is to delete all sessions.
I am still not able to identify which session causes the locking. I used some reports of the SSMS, but they did not helped me.
What can I do?