Improving performance of reports (for Reporting Services 2008 & 2008 R2) integrated with SharePoint 2010 by using the SQL Server 2012 Add-in

I discovered short time ago a simple way to improve performance of certain Reports (RS 2008 & 2008 R2) running in integration with SharePoint 2010.

Imagine the following scenario:

You are using SQL Server Add-in 2008 or 2008 R2 to integrate Reporting Services with SharePoint 2010. You observe that there is a Big different on the time shown in the execution of the report in the ExecutionLog and the real time the report takes from SharePoint.

In the following link you can see the supported combinations of SharePoint and Reporting Services Components:

Supported Combinations of SharePoint and Reporting Services Components

https://msdn.microsoft.com/en-us/library/gg492257.aspx

You can observe that:

SQL Server 2012 Add-in can be used for the versions RS Server 2008 and RS 2008 R2 as well as for RS 2012 when integrating with SharePoint 2010.

I suggest you to try using the SQL Server 2012 Reporting Services Add-in for SharePoint 2010 as it includes several improvements and it is compatible with RS 2008 and 2008 R2. You might get surprised and see that some reports might speed up. (Needles to say, always using a test environment first).

You can download it from:

Microsoft® SQL Server® 2012
Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010

https://www.microsoft.com/download/en/details.aspx?id=29068

Maria Esteban

Reporting Services Support Engineer

Comments

• Anonymous
  April 26, 2012
  Hi, Great post, do you know if you get the Power View with the Add-in and SQL 2008 /R2? Thanks, Luke

• Anonymous
  July 18, 2012
  Hi, Maria.  When you install the SSRS 2012 add-in over the SQL 2008 R2 add-in, is there anything else you need to do?  Do you have to then run in local mode?  Or do you see performance gains simply by having a new viewer against the 2008 R2 report server?  I installed it, and that seems to easy.