June 24, 2019 at 9:18 pm
I have an existing ssrs 2012 report that is running really slow this year. Last year it did not run as slow.
Basically there is a driver report and this driver report can run up to 9 subreports. The number of subreports that are executed depend upon how many reports the user selects to run.
Today I ran timings on each subreport and they took between 3 to 5 minutes for each subreport to render when only 24 customers were selected at a time.
Thus is there a way to:
1. see what is causing each applicable subreport to run so slow and/or
2. What can I do to speed up the applicable subreport(s)?
June 25, 2019 at 9:11 am
Get the query that is behind each dataset from each report. See if these queries run slow when executing directly from Management Studio (using the same parameter values as when executed from the report). Generate the actual query plans to see if extra indexing can benefit, if the estimated and actual rowcounts match and which operators cost the most. Update statistics and see if this makes a difference.
Use Extended Events or Profiler to trace the queries from the report if you cannot edit the report definition.
June 25, 2019 at 11:04 am
Thus is there a way to: 1. see what is causing each applicable subreport to run so slow and/or
ReportServer database has ExecutionLog view which contain execution history of the reports hosted on the server.
There are columns TimeDataRetrieval , TimeProcessing, TimeRendering.
They will help you to find the slowest part of the process.
See the following links
https://www.sqlchick.com/entries/2011/2/6/querying-the-report-server-execution-log.html
June 25, 2019 at 11:06 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply