Reporting services idle state RRS feed

  • Question

  • Reporting services for sql 2008 seems to go into an idle state overnight. I have tried all other solutions posted on this site and other searches and nothing seems to work. The windows server is windows 2008 and the sql server is sql 2008. The first thing each morning, the initial reports takes about 11 minutes to run. I have tried setting up a subscription report to see if this makes a difference and it runs the subscription fine each morning but the user still has to wait each morning if it is the first time anyone has accessed the site.
    Wednesday, December 2, 2009 2:00 PM


  • Hi,

    If you suspect SQL doens't run properly at night, please find the logs or add a trace on Reporting Servcies, then we can analyse what happened.

    What is the execution type of the report? Reporting Servcies won't execute the reports over and over. By default, it only execute it when accessed. So please check the exection type of the report you viewed, try to change it and let report server cache the report execution.

    Yao Jie Tang -Microsoft Online Community
    • Marked as answer by Tony Tang_YJ Wednesday, December 9, 2009 8:52 AM
    Friday, December 4, 2009 10:02 AM