SSRS Tablix render slow

Question

I have a series of reports that use a very similar Tablix object to display rows returned by a stored procedure. The render time of the report grows exponentially with the number of rows returned, when it gets over 6,000 it is well over 5 minutes, running the stored procedure in SSMS with the same parameter values returns the result set in seconds

Andy help Much appreciated

Answer 1

Hi @Andrew May
If the report is deployed, check the execution log. This will tell you roughly where all the time it spent. It's more than likely the rendering that is taking the time. Here's a quick bit of SQL to get you started.

SELECT  	   TimeDataRetrieval, TimeProcessing, TimeRendering, *      FROM ReportServer..executionlog l         JOIN ReportServer..Catalog c on l.ReportID = c.ItemID     WHERE c.name = 'MyReportName'     ORDER By TimeStart Desc  

Sometimes the memory can affect the perfermance ，you may increase the max memory used by SSRS： <WorkingSetMaximum>7000000</WorkingSetMaximum>
I refer to these threads ：https://stackoverflow.com/questions/49383116/storedprocedure-working-fast-but-ssrs-working-very-slow
https://stackoverflow.com/questions/11207049/sql-reporting-services-first-call-is-very-slow

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.