Solved

SSRS - Report 'spinning'

Posted on 2014-03-28
4
909 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 500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

732 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