Forum Discussion
Connecting to NAV via Odata result in deadlock on SQL server and NAV service tier shutdown
Dear Community, I am experiencing issues when connecting to NAV via Odata feed. With no specific pattern, the SQL database log the following error and afterwards all the NAV services lose conne...
Anonymous,
Please kill the process which is consuming the majority of Worker Threads in SQL Server using the dedicated administrator connection (DAC), then increase the “Max Worker Threads” configuration option following the instructions in this blog: https://blogs.msdn.microsoft.com/nav/2015/06/03/sql-server-worker-threads-and-microsoft-dynamics-nav/.
Regards,
Lydia
Anonymous,
Thank you for your input.
We already tried increasing the "Max Worker Threads" without resolving the issue.