dynamicsusers: Record-level locking in the SQL Server option for Microsoft Dynamics NAV

[Blog bot]

If you are designing a system for high throughput and want to minimize blocking, it's important to know in advance exactly what kind of locking behaviour to expect. On SQL Server, Microsoft Dynamics NAV uses record-level locking, as opposed to table-level locking on the native database server. In reality, SQL Server can lock a little bit more than the individual records you want to lock: It can also lock the next and the previous records. This happens when SQL Server applies a range-lock. This...(read more)

Подробнее... http://dynamicsuser.net/blogs/navsustatine...namics-nav.aspx