what are steps we have to follow in improving performance of SSRS report
*This post is locked for comments
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
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.
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,
but multiple joins means how can i do it.
Thanks in Advance.
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.
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
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).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156