Can i know why when i run a query on the management studio i wait just 1-2 sec and when i run the same query on the SSRS i wait more than 1 minute?

And Why if i run the query from the query designer the wait time its short but when i run the report the wait time its very long?

• Edited by Ste Ste 20 hours 33 minutes ago

When you run the query in Management Studio, you are strictly grabbing the data.

When you run the query in Reporting Servi=ces, the query itself is not decaying, you are also carrying the overhead of rendering the report.

More processing = more time.

• Proposed as answer by Katherine XiongMicrosoft contingent staff, Moderator 55 minutes ago

Hi Ste,

As per my understanding, the query execute in Query Designer is retrieve the data from the database. When the database is from another server where install SSMS (SQL Server Management Studio), the query will spend some time to connect that server. This will make the query execute slower than directly in SSMS. If they are in the same server, the execute time might be equal.

However, the total time to generate a reporting server report (RDL) can be divided into 3 elements: Time to retrieve the data (TimeDataRetrieval), Time to process the report (TimeProcessing), Time to render the report (TimeRendering). So it will take more time to render the report.

To improve performance of reports, we can refer to the following articles:
http://technet.microsoft.com/en-us/library/bb522806(v=sql.105).aspx
http://www.keepitsimpleandfast.com/2011/07/more-tips-to-improve-performance-of.html

Hope this helps.

Thanks,
Katherine Xiong