June 20, 2019 at 4:02 pm
I have an ssrs 2012 report that takes along time to run. I would like to look at the execution plan to see what I can do to speed up the main part of a report.
Can you tell me how I can look at the execution plan in the SSRS report and/or running the main part of the sql in sql server management studio?
June 20, 2019 at 4:48 pm
Look at the data source for the report to find what is being executed. There are several different ways to capture or find the execution plan. This article goes through the different ways you can do that:
Retrieving SQL Server Query Execution Plans
You may also want to look at the ExecutionLog3 view in the ReportServer database. TimeDataRetrieval is for interacting with the data source, extensions which would mean you want to check the query for the data source. High times in other areas could indicate a different issue so it would be good to check. This article is for the older ExecutionLog3 but still goes over the same columns and what the different areas are measuring:
ExecutionLog2 View – Analyzing and Optimizing Reports
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply