Хочу прорекламировать недавно появившийся на ‘mibuso.com’  затравочный материал по вопросу борьбы с блокировками в среде NAV/SQL от известного эксперта.

http://www.mibuso.com/dlinfo.asp?FileID=958

NAV/SQL Troubleshooting - Blocks & Deadlocks (Directions EMEA 2008)

This is the "Presentation Package" from the session presented at "Directions EMEA 2008", including the slides and various TSQL scripts to implement the introduced solutions.

>>>
Abstract:
This session is an excerpt from Stryk's training-course "Advanced NAV/SQL Performance Optimization" and will explain in detail the different locking mechanisms in C/SIDE Server and SQL Server; advanced methods for automatic block-/deadlock-detection and -analysis; and how to avoid and fix blocking-problems.

With this session practical advices, examples and templates are provided, to be instantly used in any NAV (or other Dynamics product) installation to improve the systems' performance.
<<<

Further information: http://dynamicsuser.net/blogs/stryk/archive/2008/04/18/blocks-amp-deadlocks-in-nav-with-sql-server.aspx