Dynamics NAV Job Queue – Performance Bremse Onlineshop?

Dynamics NAV Job Queue – Performance Bremse Onlineshop?

Dynamics NAV Job Queue - sometimes a programming error in C/AL code can cause users to get errors due to database deadlocks.
. A database deadlock can occur when two sessions attempt to update the same data and capture database locks in different jobs. SQL Server detects deadlocks and resolves them by resetting one of the transactions. Over the past few months, we kept noticing from different customers that a high number of deadlocks and table locks very often occurred in conjunction with using the task queue. To get an overview, we developed a graphical representation of NAV tasks for a customer upon request. This graphic is created for the Dynamics NAV "Job Queue" and the jobs defined in the SQL Server Agent.

This graphic shows the customer's task queue (Dynamics NAV "Job Queue") - each little line represents a task with its duration!

Dynamics NAV Job Queue Timeline
Dynamics NAV Job Queue Timeline

The SQL Server Agent allows the definition of jobs that consist of (multiple) job steps. And that looks like this:

SQL Agent Job Queue Timeline
SQL Agent Job Queue Timeline

It is easy to recognize that certain tasks may interfere with each other in terms of timing.

Microsoft Dynamics NAV and e-commerce is a central topic in almost all companies. Vendors promise through 100% complete integration with your Microsoft Dynamics NAV system. Customer-specific pricing, product specifications, inventory levels and more are available to the customer directly in the online store. Also works.

But what happens if, for example, the number of daily orders grows from 100 taken to 2000. And your article master contains tens of thousands of articles? How long does the "Dynamics NAV Web Services" need for the data exchange? And is the data perhaps being processed elsewhere (postings, reconciling inventory, etc.). There are probably lots of tasks running in your NAV "Job Queue" as well. If you are experiencing performance issues on the SQL Server and in your Dynamics NAV solution, please take a closer look at your SQL Server agent and your NAV task queue.

We will be happy to personally answer any further questions you may have on this topic. Simply contact us via our contact form or by e-mail to info@dynamicsproject.com!

Olav Treffurt