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.
0
Answers
You can also use the extended client monitor to see if there are reads with a wrong index.
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.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/
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
http://www.BiloBeauty.com
http://www.autismspeaks.org
Freelance Dynamics AX
Blog : http://axnmaia.wordpress.com/