Post reply

SQL Reporting Service 2000 w/SP1 and Windows Server 2003 Ent

  • February 17, 2006 at 5:18 pm

    #170698

    Running into some preformance naggs... my SP returns data in 3 seconds but it seems to take longer for reporting services to give me my report... any performance boost i can give reporting services 2000???


    Moe C

  • February 18, 2006 at 4:31 am

    #621876

    RS is putting the data into a tempdb (cache) so it can reference this for future runs/exports to excel etc.

    If you check your (execution) logs in the RS DB yuo can check to see where the time split is (data aquistion or preparing it for presentation). Remember also that if you're using (say) Query Analyser that it will start returning records before it has the full result set whereas RS will want to take the full resultset into the cahce/tempdb before rendering.

    Steve.

  • February 20, 2006 at 1:42 pm

    #622111

    well when i run the query say for example EXEC SP_NAME @,@,@,@ ... it takes like say 2 or 3 seconds to return with a result set... i know on the 1st time running the report it takes a little longer then normal.. but there on after in the same session some reports run fast but others time out... i guess what i am trying to get at is what can reporting services handle... i got these convoluted reports with all these aggregation being done on the report ie IIF(SUM(fields!SPiteam.value =0,yada,SUM(BLAH) and so on... my guess is that there are so many calculations going on this report that it takes a long time to run as well this report also has 4 subreports within a main report...


    Moe C

  • February 22, 2006 at 9:57 am

    #622670

    Any other advise out there to speed up the reporting services engine...


    Moe C

  • February 22, 2006 at 4:13 pm

    #622784

    Did you check your logs to see where the time is being taken? (e.g. data acquisiion or manipulation within RS).

    Steve.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply