Speed up Reports

(0) Share

Report

Posted on by w.sallam1

117

Hello All,

we are using AX 2012 R3 CU13, with SSRS Reporting.

we have a large amount of transactions everyday, which leads to a large database size ( around 1 TB)

the issue is that now most of the reports are taking a very long time to process,

I already make the optimization for Dynamics AX 2012 and the SQL Server, but no improvement.

I think this is because the large amount of data.

so is it possible to divide the older data from 2 years ago or so.!?

this might speed up the reports.

any ideas??

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (1)

Report

There is IDMF framework available cloudblogs.microsoft.com/.../

It allows you to archive old data, however, it's not that straight forward so may require some time to implement.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello w.sallam1,

What kind of reports do you refer to?

Do you have some examples of those reports and how they are run, i.e. what periods, filters, selections are made?

Best regards,

Ludwig

Was this reply helpful? Yes No
w.sallam1 117 on at

Like (0)

Report

thanks ievgen for your reply,

as the link you gave this is for tales only?

and will it make the performance better and faster reporting?

Was this reply helpful? Yes No
w.sallam1 117 on at

Like (0)

Report

thanks Ludwig for your reply,

almost most of our reports are getting slower,

even like printing a normal PO.. etc.

some reports on ledgers have filters and so,

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (1)

Report

If you reduce table size all queries against it will became faster for sure, including reporting. But you asked very generic question and answer could be only high-level as well. You can use IDMF to reduce DB size, also you need to check that you have maintenance plan to update index statistics and fragmentation. Maybe your SQL doesn't couple with the load and need more resources, it's hard to tell.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Good morning w.sallam1,

Have you been able to check out the information and feedback provided by ievgen?

Is there anything else the community can help you with?

If your question has been answered / problem been solved then please verify the answers to get this thread completed.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Yoko Isono on at

Like (1)

Report

Hello w.sallam1,

Have you checked the ievgen's suggestion and feedback?
If you have questions how to use IDMF, I would suggest to create an incident for Microsoft Support.

Was this reply helpful? Yes No
w.sallam1 117 on at

Like (0)

Report

thanks a lot for your reply,

I think i will do more searching about IDMF, i will try it on test environment before deciding to implement it.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Speed up Reports

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Speed up Reports

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates