Always Rowlock

This post has 1 Reply | 0 Followers

18 Posts
112 Points
Joined: 2004-8-27
Last Online:
2006-11-15 10:41
cassidy10 Posted: 2006-1-25 4:22 | Locked
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.

  • | Post Points: 6
621 Posts
7,104 Points
Joined: 2003-8-5
Last Online:
2016-2-11 22:40
Location: Washington DC
Rashed Amini replied on 2006-1-25 4:46 | Locked
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.
  • | Post Points: 5
Page 1 of 1 (2 items) | Get this RSS feed