Sharepoint integrated with SSRS 2008 R2 Issues

Question

Hello Everyone

SSRS Report takes 1 second in SQL Management Studion and in SSRS but when i check the same report on Sharepoint, it takes aroung 7-8 seconds. Can anyone help me with this issue?

Thank you

Answer 1

Hi There

Thanks for your posting. In Reporting Services, there are three processing phases when we view a report: data retrieve, report process and report rendering. When we execute the report either in Report Designer or on a report manager, the report rendering time may be different due to the rendering extension. To find out how many milliseconds of processing time is spent on each processing phase when we view a report on the report manager, you can view the report server execution log via the SSMS. For more info please see

Report Server Execution Log and the ExecutionLog3 View

SELECT [LogEntryId]
      ,[InstanceName]
      ,[ReportID]
      ,[UserName]
      ,[ExecutionId]
      ,[RequestType]
      ,[Format]
      ,[Parameters]
      ,[ReportAction]
      ,[TimeStart]
      ,[TimeEnd]
      ,[TimeDataRetrieval]
      ,[TimeProcessing]
      ,[TimeRendering]
      ,[Source]
      ,[Status]
      ,[ByteCount]
      ,[RowCount]
      ,[AdditionalInfo]
  FROM [ReportServer].[dbo].[ExecutionLogStorage]
GO

I hope this will help

Many thanks

Syed Qazafi Anjum

Answer 2

Unfortunately the Reporting Services add-in for SharePoint suffers from poor performance loading up in order to render reports.  It's slightly better using the 2008 R2 add-in than it was with earlier versions, but still very noticeably slow compared to running a report directly from SSRS report server webservice or in the standalone SSRS Report Manager.

The good news is that the 2012 version of the add-in this solved this problem, and it is backwards-compatible with SSRS 2008 R2 instances.  If you really need to improve the performance of reports in SharePoint integrated mode, I would recommend you upgrade the SSRS add-in.

Duncan

---

Duncan Sutcliffe
All postings are solely my own and do not represent or constitute Hitachi Consulting's positions, views, strategies or opinions.

Answer 3

Hello Duncan

Thank you for replying....Is there any documentation about this poor performance in sharepoint and 2012 version? I would like to go through and increases performance of the reports on sharepoint...

Answer 4

Yes Syed....I am aware of this....But I am not sure to solve that issue...

Thank you

Answer 5

Hello Duncan

Thank you for replying....Is there any documentation about this poor performance in sharepoint and 2012 version? I would like to go through and increases performance of the reports on sharepoint...

Hello Swetha,

Some people have a test on the performance about the new add-in, and post out the performance testing result. I hope their testing result is helpful to you.

http://spandps.com/2012/04/30/ssrs-web-part-performance-2008-r2-vs-2012-initial-results-sharepoint-sp2010-in/

If you have further questions, please tell us freely.

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Answer 6

Hello Edward

Thank you for sending me the link..It's really useful..If i install SQL 2012 sharepoint 2010 add -in , it should solve my problem....Do you know if SQL 2012 sharepoint 2010 add -in is compatible with SQL 2008 R2?

Thank you

Answer 7

Hello Swetha,

Thanks for your response.

SQL 2012 SharePoint 2010 add-in is compatible with Reporting Service 2008 R2. You can configure it on the Central Administrator site. Here is the screenshot from my site.

You can set the configuration on SQL Server Reporting Service (2008 and 2008 R2). If you have any questions about this issue, please tell us freely.

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Answer 8

Hello Edward

Thank you for your reply...Can i download 2012 add in from this link..http://www.microsoft.com/en-us/download/details.aspx?id=29068

Will that work fine?

Thank you again

Answer 9

Hello Swetha,

Thanks for your response.

The link is correct. I used the this file to install the SharePoint 2012 add-in on my side.

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Answer 10

Thank you very much Edward.

Answer 11

Hello Edward

Can you please tell me if I should have SQL 2012 installed on my SQL Server before installing SQL- Sharepoint 2010 add in?

Thank you

Answer 12

Hello Swetha,

SSRS SharePoint add-in can be installed independently on the SharePoint side, and you do not need install SQL server 2012 before. For more information about installation, you can refer to the MSDN article.

http://msdn.microsoft.com/library/aa905871.aspx

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Answer 13

Hello Edward

I apologize for being very late to response. If you go to this link - http://www.microsoft.com/en-us/download/details.aspx?id=29068

In requirements, it is mandatory to have SQL 2012 installed.