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

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

Leave a Comment
  • Please add 7 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Ed Price - MSFT edited Revision 7. Comment: typo

  • Ed Price - MSFT edited Revision 5. Comment: Title and tags

  • Margriet Bruggeman edited Revision 4. Comment: add

  • Gokan Ozcifci edited Revision 3. Comment: Design, Title and content

  • Margriet Bruggeman edited Revision 2. Comment: add

  • FZB edited Revision 1. Comment: typo

  • Margriet Bruggeman edited Original. Comment: add

Page 1 of 1 (7 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Margriet Bruggeman edited Original. Comment: add

  • FZB edited Revision 1. Comment: typo

  • Margriet Bruggeman edited Revision 2. Comment: add

  • Gokan Ozcifci edited Revision 3. Comment: Design, Title and content

  • Margriet Bruggeman edited Revision 4. Comment: add

  • Ed Price - MSFT edited Revision 5. Comment: Title and tags

  • Ed Price - MSFT edited Revision 7. Comment: typo

Page 1 of 1 (7 items)