Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

How to improve performance of SSRS report

Posted on by

what are steps we have to follow in improving  performance of SSRS report

*This post is locked for comments

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: How to improve performance of SSRS report

    You could set the dynamic property, and also there is a clearFieldList() method that you could use to remove what is returned, and add the fields which you do need.

    Here you go:

    theaxapta.blogspot.hu/.../sample-union-query-from-ax-2009.html

  • Jegan Profile Picture
    Jegan on at
    RE: How to improve performance of SSRS report

    I'm using Query Class( Not AOT query) with multiple table(with specific fields) joins. Here i want to set DYNAMIC propery to NO. How to do it by using X++ Code.

    My Error: Please set dynamic property on each Query datasource field list to No.

  • Jegan Profile Picture
    Jegan on at
    RE: How to improve performance of SSRS report

    I am using the query class for improving the performance for the report.But currently i am using the multiple join and less number of selection fields retrieve from the query. how can i do it using map.

    Here i want to pass it.

    Query:Insert_recordset(temp table, map, query);

    if one table means i can use below link,

    https://blogs.msdn.microsoft.com/axperf/2014/05/06/improving-ssrs-report-performance-using-new-r3-features-part-6/

    but multiple joins means how can i do it.

    Thanks in Advance.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: How to improve performance of SSRS report

    You might want to make sure that your AX database is healthy, such as you have satisfactory index and statistics maintenance, you have no SQL Server memory pressure, SQL Trace flags recommended for AX are set, you have enough TempDB files, etc. They could all be found in my below summary post and the external links:

    www.daxrunbase.com/.../ax-database-tuning-and-maintenance

    Once you establish that your database and SQL server are healthy, you could move on to identify what is slow from a data, and code perspective by doing a Trace as suggested by Martin.

    If you have identified your SQL statements are wrong, or you have bad query plans, you could try to take a look at included fields in a Query (should not be set as Dynamic if you do not use all), check if you have enough covering indexes. Capture an SQL Server Profiler trace and validate the Execution plans to identify index scans, or too large joins.

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: How to improve performance of SSRS report

    Hi Jegan,

    There is a good blog series from perf team on SSRS report performance, maybe it will help you

    blogs.msdn.microsoft.com/.../improving-ssrs-report-performance-using-new-r3-features-part-6

  • Martin Dráb Profile Picture
    Martin Dráb 230,064 Most Valuable Professional on at
    RE: How to improve performance of SSRS report

    First of all, you have to identify which part is slow, so you know what to fix. Trace Parser tool will help you with code in AX; ExecutionLog views in report server database will give you overview of the report itself (including time needed to render the report, for example).

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans