SSRS Report slow

  • prashant_kr

    Old Hand

    Points: 358

    I have one ssrs report, when we run th report, its loading page opens very late, once it start showing loading page then data comes very fast. I executed the same proc which we are using in the rdl, that proc is taking very less time. After loading the page when i chnaged the parameter and give maximum input , still the output comes in seconds. I am attaching the screen shot, which shows the pre and post loading page. Pl suggest why the laoding page come very late.

    Thanks

  • higgim

    SSCarpal Tunnel

    Points: 4090

    Are the parameters for the report pre-filled? If so, the queries which support those how are they performing?

  • MMartin1

    One Orange Chip

    Points: 27501

    It could just be the report server that renders the report may be low on Ram or disk space, running a heavy process (maybe a anti-virus scan). Have you looked at the server and its resources? Does it load this slow on all clients?

    ----------------------------------------------------
    How to post forum questions to get the best help [/url]

  • Smash125

    Hall of Fame

    Points: 3527

    need to check Report execution status in the executionlog3 table to nail it to the core.

  • Greg Edwards-268690

    SSC-Insane

    Points: 20564

    higgim (4/1/2014)


    Are the parameters for the report pre-filled? If so, the queries which support those how are they performing?

    +1

    It needs to generate all the data and render it for the drop downs.

    If you have thousands of customers, and each on can have many projects, you need to dive a bit deeper into how these are being filled.

    For example, project depends on Customer.

    So that shouldn't fill until you have picked a Customer.

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

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