Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Speed up Reports
Finance | Project Operations, Human Resources, ...
Answered

Speed up Reports

(0) ShareShare
ReportReport
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?? 

  • w.sallam1 Profile Picture
    w.sallam1 117 on at
    RE: Speed up Reports

    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.

  • Yoko Isono Profile Picture
    Yoko Isono on at
    RE: Speed up Reports

    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.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Speed up Reports

    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

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Speed up Reports

    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.

  • w.sallam1 Profile Picture
    w.sallam1 117 on at
    RE: Speed up Reports

    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,

  • w.sallam1 Profile Picture
    w.sallam1 117 on at
    RE: Speed up Reports

    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?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Speed up Reports

    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

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Speed up Reports

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans