SQL Reporting Services Report taking LONG time to process

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » SQL Reporting Services Report taking LONG...

SQL Reporting Services Report taking LONG time to process

Rate Topic

Display Mode

Topic Options

Author

Message

ramu.valleti

Posted Thursday, April 16, 2009 8:00 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, March 07, 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 »

Permissions