There are reports build in SSRS 2008 by some user. I need to improve the performance of the already-build reports. The reports fetches a lot of data and run very very slow.
I googled and found certain steps that can be taken to improve the performance of the reports which are listed below.
- Caching of Reports
SQL Server End
Creating Stored Procedure to be used in reports (reports now used free SQL Query)
Removing nested views structure
Creating Index on most use tables and Indexed Views.
Can you suggest possible methods/solutions which could be helpful to improve the performance of Reports in a drastically way.