Performance Issue on Dynamics NAV SP1 Native DB

Jay2007

Hi there,

I am having performance issues on an SP1 Native DB and was just wondering if anyone has any ideas on how to improve the performance??

The issue is when running Report Object 120 Aged Accounts Receivable. It is very very slow to run. I have tried optimizing the tables used by this report and expanded the database to 10GB to see if extra free space would help but no luck !

The database stats are as follows :-

Database Size 80000000 KB
Database Used 5079024 KB
DBMS Cache 8000 KB
Commit Cache Yes
Object Cache 32000 KB

The Cust. Ledger Entry table stats are as follows :-

No. of Records 176335
Record Size 689
Size 118632 KB
Optimization 98.0


Also, I am running this database locally on my laptop with only myself connected so no network or concurrency issues here.

Does anyone have any ideas what else I could do to improve performance?

Thanks in advance.

Marije_Brummel

Best is to either turn on Client monitor or the Session monitor to see how many reads there are. This is ususaly the issues when reports are slow.

You can also use the extended client monitor to see if there are reads with a wrong index.

kriki

You are only using 8MB as DBcache on the server? :shock:
Best increase that to the maximum (about 750MB). Of course this memory must NEVER be swapped to disk by Windows otherwise you lose the advantage of the DBcache.

nunomaia

Have you tried to do the same operation but opening the database directly without any database server?

Jay2007

Hi there,

Sorry about the delay in replying but I was unable to access the site for most of the day after posting my question. I have tried Kriki's suggestion of increasing the DBMS Cache to the maximum of 750MB and this has done the trick.

Thanks once again !

Jay

Savatage

Was there a reason for allocating to little to begin with?

nunomaia

If I'm not in mistake is servers default