Almost three years ago, I posted about why Reporting Services takes so long to respond to the first request if it has been sitting idle for a long time (like overnight). The original post can be found at http://blogs.msdn.com/b/sqlblog/archive/2007/11/09/reporting-services-staaaarrrrrtttt-up.aspx ... . For those of you who don’t want to read it, the core conclusion was that (at least on my hardware), SSRS was taking about 30 seconds to start up after the application domain had been recycled. The post was in response to the question I was getting (and still get) about why SSRS takes so long to start up. The answer (for those of you who don’t want to bother reading the old article), was that SSRS has to do a ton of work to load all of the required dependencies, plus read the configuration files and decrypt the data in the catalog database.
I recently set up a new installation of SSRS 2008 R2, so I thought I would do the same comparison. I had figured to see similar results, so you can imagine my surprise when the numbers averaged about 15 seconds!!! I attribute some of that to a better machine, but my primary machine is not too much better than my server machine was back in those days (quad-core vs. dual-core, but similar RAM and clock speeds). In fact, some quick benchmarks confirmed my thoughts – the new machine is better at higher workloads, but at the relatively low level of work I am doing for these tests, they are about the same.
Here is the updated code:
Sub Main(ByVal args() As String)
In summary, even though I would love to see some improvement in this area, my own testing shows that SSRS 2008 R2 starts up from a cold start in about half the time is took SSRS 2005.
Your mileage and results will vary depending on your hardware configuration, so don’t take my results to use in a proposal to your management. If you do, I will disavow any knowledge of the above testing!!
Do your own testing, but please share your results. I would love to hear if other people see similar startup improvements between the two versions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.