Wikis - Page Details

First published by Margriet Bruggeman (3MVP, Microsoft Partne)
When: 23 Apr 2012 1:29 AM
Last revision by Ed Price - MSFT (aMicrosof)
When: 16 Apr 2013 2:45 PM
Revisions: 12
Comments: 7

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

SharePoint 2010: Best Practice Troubleshooting an SSRS Report That Times Out

What to do when an SSRS report times out? This sort of problem can be really hard to troubleshoot, but here's what you can try:

First of all, check how the sql query performs. If it's running slow, than the problem is query related instead of SSRS report related and you'll need to work on that part.
Check if the amount of data rendered by the report is the problem. Do this by creating a new report that displays the results of your query in the simplest way possible. If it takes a long time to render, you're displaying to much data on a single report and you need to either change the amount of data shown in the report or look for another reporting technology and test if that's able to perform better (such as Silverlight Chart Controls).
Now add the report logic (if there is any) step by step, and see when it breaks.
As an alternative. It's possible that somehow the .rdl file got corrupted. Rebuild it step by step, including the same query and logic. I've seen cases where that process solved the problem completely. This is another path you can follow.

To do:
Add references about SSRS related log files and specific SSRS performance counters.

Please note: Also check out the SharePoint 2010 Best Practice Overview page at http://social.technet.microsoft.com/wiki/contents/articles/8666.sharepoint-2010-best-practices-en.aspx