Help:Performance issue-Posting sales invoices takes 5min/inv

MiBuYme · 2007-01-17

I have a bad problem that affects the activity of entire company. Posting one sales invoice for a custumer that has multiple ship-to addresses takes about 5 min. Taking in consideration we need to post~1000 inv/day and having ~10 customers with this particularity.......it's becoming a sensible issue. Can you help?

Technical data:
Navision 3.6,
SQL database on Sql Server 2003,
8GB=database dimension,
approx.1mil records in cust.ledger entry table

What I noticed so far:
- This didn't happen when the database was smaller, it came out lately, after 9 month activity
-If I restore my data in a new Navision native database this issue doesn't occur (5sec/invoice), so it must be an SQL database problem
-The point in which appears the delay is when starting "Posting to bal.account" in codeunit 80, but I could't detect where's the problem.

Did anyone face this problem? Any kind of solution?

Thanks!!!

DenSter · 2007-01-17

Check:
- transaction log, it might have to be truncated
- statistics, run the sp_updatestats stored procedure to update the statistics on your database indexes
- the number of SIFT indexes, you may have to tweak that to enhance performance

Marije_Brummel · 2007-01-17

My suggestion is to seek help from a performance expert. They have a step-by-step procedure for these issues.

SQL 2003 does not exist, so I assume it is 2000.

3.6 is neither stable, nor supported for SQL. You should upgrade to 4.0SP3.

Do you have a maintenance plan?

Are the Sift indexes tuned?

Have you configured a optimum index plan for your company?

SQL needs tuning.

DenSter · 2007-01-17

Actually, 3.6 is not supported anymore at all.

MiBuYme · 2007-01-18

Thanks everybody for suggestions!

Help:Performance issue-Posting sales invoices takes 5min/inv

Comments

Categories