Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Sharepoint Integrated mode vs Native mode Expand / Collapse
Author
Message
Posted Friday, July 25, 2014 8:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:47 AM
Points: 130, Visits: 470
Hi,

We have reports in SharePoint integrated mode which are really slow when compared to native mode. I have been asked to research and give info on what exactly causes the delays.

Can you point me to articles which give me information as to what happens when a report is run from SharePoint server and where does it log.

Thank you,
Veena
Post #1596229
Posted Wednesday, August 6, 2014 11:46 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 15, 2014 12:59 AM
Points: 241, Visits: 591
Veena,

Your observation about SSRS performance degradation in SharePoint Integrated Mode is not uncommon unfortunately. The specific solutions will depend on the versions of SSRS and SharePoint that you are running.

I have found the following references to be helpful:

Melissa Coates has a very thorough discussion of her issues in dealing with the same issue at:
http://www.sqlchick.com/entries/2011/1/25/whats-up-with-the-slow-ssrs-r2-rendering-in-sharepoint-2010.html

The SQL CAT team also wrote a white paper on this topic, "Reporting Services Performance in SharePoint Integrated Mode in SQL Server 2008 R2". While the original site has been removed, the paper was included in an eBook on BI and analytics that you can find at:
http://blogs.msdn.com/b/sqlcat/archive/2013/10/23/sqlcat-com-ebook-downloads.aspx
The specific paper begins around page 139.


Hope this helps,
Scott Thornburg



Post #1600466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse