Announcements
No record found.
what are steps we have to follow in improving performance of SSRS report
*This post is locked for comments
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).
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
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.
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.
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.
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
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Prashant Singh 2
