Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Reporting Services Report taking LONG time to process Expand / Collapse
Author
Message
Posted Thursday, April 16, 2009 8:00 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 7, 2013 12:16 AM
Points: 381, Visits: 340
Hello there,

I've a Report which is developed using sql query, and is taking 2 min to process when i run it from reportserver.
But when i execute the same sql query in SSMS its taking 10 to 20 sec.

What could be the possible reason for the report server to take long time to execute the same query and why it is not taking that much time in management studio?

Please suggest me how to improve the performance of report server..!


Regards,
Ramu




Ramu
No Dream Is Too Big....!
Post #698455
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse