SQL Performance while Posting Item Tracking in Output Journa

HaraldAyasse

Hi,

when we are posting one Output Journal line with 5000 pieces and item tracking is active (means 5000 serial no. are linked to the Output Journal line) the system needs round about 2.5 hours time to do the posting.

We are using SQL 2000 and NAV 4.00 SP3.

Does anyone have any idea why NAV takes this huge amount of time and is there any solution to make it faster?

Thanks
Harald

Marije_Brummel

It is very difficult to give one single cause for that.

Traditionaly NAV is overindexed and sometimes even wrongly indexed which causes especialy posting transactions to be slow.

This could be the case in your installation.

You can check this by running SQL Profiler and trace SP:StmtCompleted with a filter on 50 milliseconds.

If inserts take longer than 50 milliseconds this is the case.

There can also be other issues like SQL Cursors, memory/checkpoint, disk performance or network, but traditionaly the indexes are the cause.

Good luck.

vikram7_dabas

u have to check ur coding there will be some problem in coding if u r using setrange for filter than plz use get function it if u can apply in ur coding.ok

kriki

[Topic moved from Navision forum to SQL Performance forum]