March 7, 2008 at 1:46 pm
Does anyone know why the same exact query (stored procedure) run from Query Analyzer would take 27 seconds but from Reporting Services 2000 it would take 13 min 19 secs?
I am not doing anything overly complex in the report besides some normal stuff like grouping, summing, counting, etc. I do have a couple simple VB.Net functions that do simple things like check for a blank and display the word Null in place of a blank. The report in the scenario I tried rendered 34 pages and the query is returning 6468 rows, so nothing major here.
Is there any sort of maintenance that needs to occur on the Reporting Services databases (ReportServer & ReportServerTempDB)? This is at a client and they may not have the latest service packs. Were there any performance issues fixed by service packs that anyone is aware of?
Any other ideas would be greatly appreciated...
March 11, 2008 at 1:59 pm
I ran into the same problem with SSRS2005. I had an sp that took only 10 seconds to retrieve the data, but SSRS2005 took about 3 minutes to run. The data was VERY simple. However, when I did some of the grouping, it seemed to creep. I ran the query tuning advisor on my sp and it told me to not update statistics and put some indexes on some tables. Now it runs in 1 second. Problem solved, I hope this helps.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply