Solved

SSRS - Report 'spinning'

Posted on 2014-03-28
4
847 Views
Last Modified: 2014-04-14
I am certain that I have seen this problem before, but for the life of me, I can't remember what it was.  

A customer of mine is describing a problem with their SSRS performance.  In their words, "when we try to execute a report, the system spins for 8 seconds, loads the page, and then spins again to process report".  

Their reporting layer is in SharePoint 2013 Farm, which is three servers (web, SSRS and database).  Everything is SQL v2012.

Like I said, I feel like I had this problem before.  I believe there was a tweak or two for the SSRS configuration, that reduced the spinning, and improved the performance overall.

I am just looking for some good direction from the SSRS Experts.   Any information is truly appreciated.
0
Comment
Question by:dbaSQL
  • 2
4 Comments
 
LVL 12

Expert Comment

by:Tony303
Comment Utility
Is the first spinning related to the report getting the parameters populated for the user then to choose their filters perhaps?
0
 
LVL 9

Accepted Solution

by:
edtechdba earned 500 total points
Comment Utility
Have you considered changing SSRS from Sharepoint Integrated to Native mode?

This article may be of interest to you:

SSRS 2008 R2 and Sharepoint 2010 - performance problems

This one also appears to point to this being a mode type of issue (Sharepoint to Native):

What’s Up With the Slow SSRS R2 Rendering in SharePoint 2010 Integrated Mode?
0
 
LVL 17

Author Comment

by:dbaSQL
Comment Utility
Tony303, no. It's not collecting parameters for the report. It is just spinning at startup, for any/all reports.

edtechdba, the link you've provided on the performance problem is interesting.  It sounds like exactly what is going on, except that the sharepoint vs native mode performance sounds like a bug with 2008.  My client is using SQL and SSRS v2012, along with SharePoint 2013.  Do you think this still applies?

If this is a matter of the SharePoint integrated mode, then it seems the problem is still there in SQL v2012 and SharePoint 2013?

This is also in that performance link that you referenced:

>>>As a workaround, please try to open the SharePoint site and the SSRS web services URL before rendering a report. This may reduce the compiling time.

Do you understand what this means, or why it would be of any use?
0
 
LVL 17

Author Closing Comment

by:dbaSQL
Comment Utility
The 'spinning' persists, but I see no reason to keep this inquiry open.  I will award you the points, I appreciate the time and the references you've provided.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now