Always Rowlock

If you check the "Always Rowlock" box in 4.0 SP1 it appears that SQL still escalates locking to a table lock for large batch posting jobs. Can anyone confirm this or maybe I don't understand fully what "Always Rowlock" does. Thanks.

Brian.

cassidy10
  • The Always rowlock was added by navision to fix for a bug in sql 7. They removed it but added that as an option.
    Basically with every insert into the sql it will call with rowlock statement.
    So that is the history of that option.


    Now with record locking, table locking. SQL determines when to lock a record and when to lock a table to maintain serializability. Basically if it become to complicated to maintain record locking, SQL switches to table locking. SQL determines that Navision can#%92t do anything about it.

    Rashed Amini
Related