It has been really long time since I have blogged. However I will try to blog as often as I can.
Very Recently, I performed a SSRS Performance Review to tune performance reports for one of our customers. While analyzing some long running reports we identified some usual issues which may not be aware while we are designing the report or working on small dataset. But when the same report is migrated to Production DW with large dataset & with number of concurrent users fetching the report, the response time of the report degrades.
In the following presentation, I have listed the common tips and tricks to performance tune the reports
Hope this helps !!!
Parikshit Savjani
Premier Field Engineer