Performance of SSRS Report.....

Question

.Hw we can improve the performance of ssrs report..Its taking huge time to execute the report.We implement paging in SSRS...but its not effective...... Any body can help on this matter.....

Answer 1

Sounds like you need to identify your expensive queries and possibly missing indexes. See this answer to get started.

Answer 2

Also look at drill down report design where you click on summary to get details through a separate query. and if you are doing a lot of calculations in your query, check if you can precalculate those values periodically and store them in a table. Check for indexes on your tables and use 'with nolock' query hint in your SQL