Poor performance posting shipments on NAV5 SP1 SQL

cschueller
cschueller Member Posts: 6
edited 2013-09-25 in NAV/Navision Classic Client
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

Comments

  • bbrown
    bbrown Member Posts: 3,268
    Start by using the "Client Monitor" to determine where the bottlenecks are.
    There are no bugs - only undocumented features.
  • cschueller
    cschueller Member Posts: 6
    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.

Categories