Microsoft Dynamics AX (Archived)

How to improve performance of SSRS report

(0) Share

Report

Posted on by Jegan

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

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

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).

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

Like (0)

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

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

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.

Was this reply helpful? Yes No
Jegan on at

Like (0)

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.

Was this reply helpful? Yes No
Jegan on at

Like (0)

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.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

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

Was this reply helpful? Yes No