I have a stored procedure that is querying 4 tables with Huge amount of data. Executing the Stored proc with input filter parameters takes about 4 - 5 seconds to run in SQL Management studio and pull all the data required.
This stored procedure is used in a SSRS report which is deployed in a Reporting server. When run in the SSRS server the report takes about 2-3 mins to render and stops responding most of the time. Same filters as the ones used in SQL Management studio are applied on the report.
What are all the possible reasons this delay is occurring in SSRS but not in SQL Server?
NOTE: Due to client policies i am not allowed to share any code or additional details. Apologies for that
Aucun commentaire:
Enregistrer un commentaire