Thursday, November 13, 2014

Integrated and Native Mode SSRS Performance Comparison


SSRS Performance in Native and Integration Mode

o begin with, let me briefly touch on process in both. SSRS in Native Mode:





Steps:
End user requests a report to a Reporting Service Engine.
Reporting Service Engine retrieves report definition from the Report Server Catalogue.
Reporting Service Engine sends query requests to the database(s).
Reporting Service Engine sends the extracted report to the end user.
End user sends request to Reporting Service Engine to format output (Excel, PDF etc..).
Reporting Service Engine returns the report in the end user’s requested format.





Steps:

End user requests a report to SharePoint Web Services.

SharePoint Web Services retrieves the report definition from the SharePoint Catalogue.
SharePoint Web Services requests a report from the Reporting Service Engine.

Reporting Service Engine queries Report Server Catalogue to compare and authenticate report definition with the report definition received from the
SharePoint Catalogue.
Reporting Service Engine sends query requests to the database(s).
Reporting Service Engine sends the extracted report to the SharePoint Web Services.
SharePoint Web Services sends the extracted report to the end user.
End user sends request to SharePoint Web Services to format output (Excel, PDF etc…).
SharePoint Web Services requests Reporting Service Engine to send report in the end user’s requested format.
Reporting Service Engine returns the report in the end user’s requested format to SharePoint Web Services.
SharePoint Web Services returns the report in the end user’s requested format to the end user.
We see that communication in SSRS in Integration Mode takes more steps than in SSRS in Native Mode and this is reflected in performance. However, the
difference is microseconds.

The choice between Native and Integration mode really depends on the organization as
performance isn’t much of an issue. If they prefer the SSRS in
Integration Mode with improved performance, they can add more computing resources to the infrastructure.

Google+ Followers