General overhead performance differences when you view reports in SharePoint integrated mode versus in SharePoint native mode

Article translations Article translations
Article ID: 2216504 - View products that this article applies to.
Expand all | Collapse all

SUMMARY

When you run a report in the Microsoft SharePoint integrated mode in Microsoft SQL Server Reporting Services, the report may run noticeably slower than when you run the same report in native mode.

MORE INFORMATION

In SharePoint integrated mode, reports typically run slower than when the same reports run in native mode. One main cause of this latency can be attributed to SharePoint object model calls that are made. This issue is usually most noticeable where there are multiple Report Viewer Web Parts on a single page that is running small reports.

Other performance issues can usually be isolated to these two areas in SharePoint:
  • Reporting Services SharePoint plug-in. This plug-in makes many SOAP calls to the Reporting Services server.
  • SharePoint overhead performance, and this includes SharePoint object model calls. This overhead performance is primarily the cost of many of the SharePoint services and the SharePoint implementation of the SQL Server.
In SQL Server 2005 SP3, the number of SharePoint object model calls that SQL Server 2005 Reporting Services (SSRS) makes are optimized. This optimization reduces some latency when you compare report performance to native mode. Additional improvements were made in both SQL Server 2008 Reporting Services and SQL Server 2008 R2 Reporting Services as part of the maturation of the product and to improve the overall integration of these two products.

Please also see the following White Paper by the SQL CAT. This White Paper covers the overall performance aspects of Reporting Services in SharePoint mode versus native mode.

Reporting Services Performance in SharePoint Integrated Mode in SQL Server 2008 R2:
http://sqlcat.com/technicalnotes/archive/2010/11/03/reporting-services-performance-in-sharepoint-integrated-mode-in-sql-server-2008-r2.aspx


Properties

Article ID: 2216504 - Last Review: November 9, 2010 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
Keywords: 
kbinfo kbperformance KB2216504

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com