SSRS report in Visual Studio takes 2 minutes to run, the deployed report when run from Reporting Services takes forever. Why?

Question

I have a report that runs in 2 minutes in Visual Studio connected to the production database (16k rows, 50 columns),
but it takes more than 16 minutes when run by Reporting Services in production after deployment (I have to cancel each time).
Both dev and prod boxes have the same CPU and memory assets.
Also, when I simply run the same SQL view in the production database the 16k rows are returned in 20 seconds.
What can I do to increase the performance of the report when run by Reporting Services in production?

Answer 1

Hi,

Increase SSRS Performance is a very common issue and always asked by customers.

In the ReportServerDB you will find a table in views called ExecutionLog3.

Look up your report and check the latest execution instance.

This could tell you the break-up of the times taken - for data retrieval, for processing, for rendering etc.

You will find the part that you spent the most time on running the report, and then decrease the time with the different part.

For reference:

bb522806(v=sql.105)

In addition, you may also try the solution to speed SSRS reports with cache the reports.

caching-reports-ssrs
preload-the-cache-report-manager
performance-snapshots-caching-reporting-services

Hope it will give you some ideas.

If you have any question, please feel free to let me know.

If your problem has been solved, please mark "accepted answer" on my reply, thank you for your understanding.

Regards,

Zoe