Article ID: 2216504 - View products that this article applies to.
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.
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:
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: