674
Hi all.
In NAV 2013 R2, there is no option to use "always rowlock" in DB options.
So, whether table lock always use in NAV 2013 R2 process? Or sometimes it use rowlock and pagelock?
How I know the lock that is used in NAV 2013 R2 process?
Can I set the "DB lock type", somehow?
Thanks.
*This post is locked for comments
Concurrency is such a big issue in Dynamics NAV that whenever possible we use MS SQL Express with Visual Studio .net
NAV can only work with MS SQL in either SERIALIZABLE ( all write-transactions ) or DIRTYREAD ( read only reports ) transaction isolation mode. This is very HUGE limitation.
Basically it means concurrent work inserting data into the same table is impossible because most new records fall into the same page and PAGELOCK prevents working concurrently.
Always rowlock in NAV was helpful but MS discontinued it because it was a significant drawback on MS SQL performance.
We ended up setting up separate NAV DB for each user who is supposed to be entering new data (sales info) and then replicating data into one common back-office database
Agreed with Rashed.
Concurrency is a big issue in Dynamics NAV. One of our client is always complain about G/L and Item Ledger entry table locks, but we are not in a position to provide a solution to them.
If a posting is taking long, then all the other users have to wait till that finished. This get worse when the costing is set to Average. It is always a limit we can do by optimizing CAL code and it is high time for Microsoft to introduce new method to optimize table locks from CAL side.
Hello Concurrency in NAV is terrible. During Posting it basically acts like a semaphore and locks the GL entry.
If you transactions take long, then you are out of luck.
SQL basically controls how to set the lock, and it could be on specific record, or Page (multiple records), Range lock or table.
There is no way around it.
Hi Jose Angel,
This option is not available since NAV 2013. That option was for compatibility with 32-bit architecture, and since SQL 2005 it wasn't very useful.
The "official" argument is that you should solve or prevent the ocurring blocks by optimizing the C/AL code :-))
Good luck!!
sorry, i didn't get you. would you please explain in more details?
Automatic Lock/release Objects in NAV 2013 and 2013 R2
community.dynamics.com/.../automatic-lock-release-objects-in-nav-2013-and-2013-r2
Locking and Unlocking Objects
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (