We have few of our SSRS reports running very slow. These SSRS reports fetch data from a reporting server database which is acting as subscriber for the replication process. i.e. we have an OLTP DB server where Database 'A' is replicating on reporting sever as Database 'B' from where the SSRS reports fetch their data.
The reports are running very slow when we try executing their SQL query manually. I am new to reading executions plans, so as highlighted its pointing clustered index seek as high operating cost, which I am not sure on how to look upon:
Also, the DB is 350 GB in size and sql server is 2005, SP4.
Moreover, I made sure my reindexing and update stats jobs are running properly and yes they are.(Using OLA's Index script).
Please refer to below execution plans for the SQL query executed from one of the SSRS reports.
Kindly help or provide any inputs that may help in resolving this slowness!
Looking at the information provided, the estimates and actuals are very different e.g estimated executions 15298 actual 9311176. I'd suggest that you could start by updating the statistics on the tables and see if that helps.
There will generally be somewhere in a plan that appears as the bottle neck and there will generally be something that has a high number, that doesn't mean it's bad - the plan has to come to 100% after all.
How long did it used to take and how long does it take now?
answered Mar 23, 2015 at 12:08 PM