Condividi tramite

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

  • Articolo

 

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:

Report server

Add-in

SharePoint version

SQL Server 2012

SQL Server 2012

SharePoint 2010

SQL Server 2008 R2

SQL Server 2012

SharePoint 2010

SQL Server 2008

SQL Server 2012

SharePoint 2010

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.