5
Hallo.
At work we use MS Dynamics 2016. We experience performance degradation every day due to several “tables being locked by another user” error type problems. One of the ways in which we are able to temporarily resolve this challenge is by compiling vendor ledger entry and savings ledger entry tables. Sometimes we are forced to restart the application server. The system becomes quite fast after compiling the two tables. Is there a permanent solution.
Do you see any errors or warnings in the event log? there are many reasons for the table locks, poorly designed code or customization, there is a stryk sql block detection code which will track what causing the table locks and who is causing that may help to analyze the issue and fix it.
dynamicsuser.net/.../blocks-amp-deadlocks-in-nav-with-sql-server
Hi Leebarn,
Please check the folliwng solutions for the same issue:
[View:https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/213488/table-locked-by-another-user-ile-g-l-many-other-tables:750:50]
[View:https://docs.microsoft.com/en-us/dynamics-nav/monitoring-database-locks?redirectedfrom=MSDN:750:50]
If you find this information helpful, Click Yes to Verify the answer to share with other community members.
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...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (