Report running very slowly RRS feed

  • Question

  • Hello everyone.

    I've been away from working with SSRS reports for over a year, and I'm assigned to do some reports very recently. As the topic implies, I have a report which is very slow and takes almost 15minutes to run. The funny part is, when I run report's query in SSMS (after checking the execution plan and creating appropriate indexes) it takes only 8 seconds to complete. Any clue what is the cause of this difference running time and the solution to fix it up?

    I must add that having report cache is not acceptable, as the report is supposed to return up-to-second result and it runs against the production server. 


    Wednesday, August 17, 2011 4:06 PM