SSRS Report slow

  • 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

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

  • 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?

    ----------------------------------------------------

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

  • 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 4 (of 4 total)

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