Performance issue on SSRS 2008 R2 reports
Hi,
I am beginner in SSRS.I have developed two reports .I have 4 filters in one report and 7 filters in other report.The execution time for each report is around 4-7 min. Can anyone pls guide me in providing some tips to reduce the execution
time??
Thanks in Advance
Regards,
Swathi.CRegards, Swathi
July 26th, 2011 12:45am
Hi Swathi,
Thanks for your question here.
Actually, if we use filter in the report, the results being queried from database engine, then filtered in the report side. For
complex filters, the report engine need to analysis them then filtered the results again. In addition, the report server has powerful application on report management, for the query performance, the database engine is better than the report engine.
Based on previous analysis, if it is possible and you have the permission to edit the T-SQL query of the dataset, I would recommend
you filter the results in database engine side.
In order to improve the performance of the Transact-SQL, please reference below two articles:
Transact-SQL Optimization Tips
Transact-SQL Performance Tips
Hope them help you.
If there is anything unclear, please feel free to ask.
Thanks,
Sharp Wang
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 28th, 2011 2:30am
http://msdn.microsoft.com/en-us/library/bb522786.aspx. has some concepts with respect to performance improvemnet in SSRS 2008R2.Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!
July 28th, 2011 3:21am