Performance Issue on Dynamics NAV SP1 Native DB

Jay2007Jay2007 Member Posts: 50
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.

Answers

  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
  • krikikriki Member, Moderator Posts: 9,115
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • nunomaianunomaia Member Posts: 1,153
    Have you tried to do the same operation but opening the database directly without any database server?
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Jay2007Jay2007 Member Posts: 50
    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 ! :mrgreen:

    Jay
  • SavatageSavatage Member Posts: 7,142
    Was there a reason for allocating to little to begin with?
  • nunomaianunomaia Member Posts: 1,153
    If I'm not in mistake is servers default :)
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
Sign In or Register to comment.