Poor performance posting shipments on NAV5 SP1 SQL

cschueller

Hi all,

I'm having a big issue concerning shipments on a NAV5 SP1 on SQL Server 2008. My customer is used to post 100 to 1000 lines for one shipment, and the process takes almost 2 seconds per line ! It's only shipping, no invoicing and don't have much dimensions on lines (maybe from 2 to 6 dimensions max). I have disabled analysis views automatic updates and cost adjustment is set to "Never".

So I think the issue comes from SQL, but I'm not an expert so I'm asking you some help maybe to tune the code in codeunits 80 or 22 or just to set up differently the SQL Server.

Thank you !
Cédric

bbrown

Start by using the "Client Monitor" to determine where the bottlenecks are.

cschueller

Thanks for your idea !

We monitored the process and the time consuming operations comes from a CALCSUMS in the Warehouse Entry table. The MaintainSQLIndex and MaintainSIFTIndex on a key was not checked (it is standard NAV!). So SQL used the primary key, and thats taking, .25 seconds each line.

Now the process is "normal" and takes half the time. Can we diminush this process duration by optimizing something ?

Thank you.