Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Reporting services native mode Vs Integrated mode

  Asked By: Ganesh    Date: Apr 24    Category: Sharepoint    Views: 8570

We have a SharePoint dashboard running that uses a custom web part to display reporting services reports (configured in native mode). The reports take around 6 seconds to appear and we'd ideally like them to appear faster.

Can anyone let me know if configuring it in Integrated Mode would make any difference? If yes, could I still continue to use the ASP.Net report viewer control to display the reports in integrated mode?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Jason Anderson     Answered On: Apr 24

With Integrate Mode the report  rdl are on sharepoint  and not in report Database, interact directly with security Trimed of sharepoint permissions.
The fact of being so slow on can be for many reason, the ideal is have a separate structure and application pool, for Reporting Services Integration Mode, verify your SQL query, your cubes and mdx querys to improve performance, normaly render problem are on querys to database.

"SharePoint and SQL Server Reporting Services - Installation and Setup"
blogs.msdn.com/sharepoint/attachment/4194088.ashx
blah.winsmarts.com/..._Installation_and_Setup.aspx

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies
www.microsoft.com/.../details.aspx

Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
www.microsoft.com/.../details.aspx

The first time can take time and you problably will need to warmup the reports, and use some IIS compression to improve your rending problems and other RS and Sharepoint Techinque to improve performance, here some articles...

Planning for Scalability and Performance with Reporting Services
technet.microsoft.com/en-us/library/cc966418.aspx

Tune Web server performance (Office SharePoint Server)
technet.microsoft.com/en-us/library/cc298550.aspx

 
Didn't find what you were looking for? Find more on Reporting services native mode Vs Integrated mode Or get search suggestion and latest updates.

Related Topics:



Tagged:          

 

Related Post