SQL connection error Nav 2016

(0) Share

Report

Posted on by Lucitus

Our SQL server encounter massive queries requests from Nav application to a point of triggering SQL Connection error for which all jobs have to be terminated. Do you know why would a out of the box Nav application trigger so many requests. Is this a common error for a single transaction to process 2500 items?

All responses (1)

Answers (0)

Tabrez Ajaz 785 on at

Like (0)

Report

RE: SQL connection error Nav 2016

Executing massive queries on SQL is common if so many users are using NAV simultaneously and the massive amount of records or available in a single table. This can be avoided if a single user performs some operation on items table when others do not.