SSRS Load Time

Unknown said:

I'm trying to get an idea of typical SSRS report generation time.  Many of our users have complained about the length that SSRS reports take to generate (probably comparing them to Infomaker reports), and I'm not sure if this is expected.  In particular, the Plan Summary report in v.12 takes up to 10 minutes to generate when running on certain campaigns.  Do others experience this sort of load time?

Generally, yes, in my experience, SSRS reports are slower than IM reports. Some things that I've found helpful to look at:

1.) The table reportserver..Executionlog2 is very informative, especially the columns TimeDataRetrieval, TimeProcessing, and TimeRendering. Here you can at least see what step(s) are taking the longest.

2.) Make sure server memory is being allocated properly, e.g. in the past, we found that SQL Server would eat up all the RAM if a max server memory value wasn't set.

https://msdn.microsoft.com/en-us/library/ms178067(v=sql.110).aspx

The Plan Summary report just took over four minutes to load our largest current campaigns, most of it in TimeDataRetrieval. Since it's a standard report, we're kind of stuck with it the way it is, but it certainly looks like a good candidate for some sproc optimization.

Hi Chris,

Thanks for the information. I hadn't ever looked at the Report Server tables before - very informative. This reveals that the data retrieval step is holding us up with the Plan Summary - and it's actually now causing an Authentication error when trying to save as csv due to time out issues -- so we'll have to do something about it.  My next step will be to look into server memory allocation...

Thanks again.

Frannie