?
Solved

SSRS - Report 'spinning'

Posted on 2014-03-28
4
Medium Priority
?
948 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 12

Expert Comment

by:Tony303
ID: 39963032
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 1500 total points
ID: 39963033
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
ID: 39972516
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
ID: 40000301
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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

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