Always Rowlock

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

This post has 1 Reply | 0 Followers

18 Posts
202 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.

Brian.
Male
621 Posts
10,435 Points
Joined: 2003-8-5
Last Online:
2013-1-18 14:55
Location: Washington DC
DynamicsNAVMVP
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.
Page 1 of 1 (2 items) | Get this RSS feed | Bookmark and Share