Thursday, December 18, 2008

SQL Server SP3 and SSRS SharePoint Integrated Mode

Many already know but SQL Server 2005 has released Service Pack 3. Here is the SQL SP3 Bug List. How does this affect MOSS – there is a fix for performance with SQL Reporting Services that run in SharePoint Integrated Mode.

"FIX: Rendering a report is much longer in the SharePoint integrated mode than in the Native mode, especially when you put more than one report viewer Web part on a SharePoint Web page"

A colleague (Steve Mann) stated he did some quick testing that resulted in:

  • Direct Report Rendering (clicking on rdl from a reports library) - 70% improvement on initial load; 50%-90% improvement on report refresh
  • Report rendering on page with the Report Viewer webpart - only saw a 15% improvement

Do not hold me to these stats. As well reporting services will not always be the performance problem…

However this is a pretty good improvement and you should consider rolling this out.

2 comments:

Virtual said...

Hi Jason,

I can't find "FIX: Rendering a report is much longer in the SharePoint integrated mode than in the Native mode, especially when you put more than one report viewer Web part on a SharePoint Web page" in SQL Service Pack 3 list of bugs. Was it supposed to be in the list?

Thanks,
RDM

Jason Apergis said...

Sorry - cannot recall...