Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSRS Sharepoint Integrated mode vs Native mode Expand / Collapse
Posted Friday, July 25, 2014 8:09 AM


Group: General Forum Members
Last Login: Thursday, August 4, 2016 7:51 AM
Points: 159, Visits: 558

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,
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: Today @ 2:30 PM
Points: 241, Visits: 755

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:

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:
The specific paper begins around page 139.

Hope this helps,
Scott Thornburg

Post #1600466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse