Reporting Services in SQL 2005 is hosted in IIS. IIS has a performance optimization built-in that you cannot disable (AFAIK), which shuts down an application once there is a period of 20 minutes of inactivity. This is governed by the Idle Timeout IIS
Read More...
I wanted to provide a quick note on how to scale test Reporting Services. Partially I'm posting this so I don't lose the link :-). Often we are asked how best to scale test Reporting Services and what scale numbers to expect coming from a particular configuration.
Read More...