Reporting Services startup lag
Posted on 2006-05-09
I've recently installed reporting services on my server. My problem is when I go to the reports default directory and if no one has accessed the server for a few hours it takes me about 30 seconds to a minute to load the page. If I refresh or go to the page within a few minutes of the first load, the page loads right away...
It sounds like the server is on idle and once a kick start it it runs perfectly.
Here are the specs for that server:
Windowns Server 2003 (SP1), SQL Server 2000 (SP4)
4 Inter Xeon Processors (1.4GHz)
10GB of RAM
Turn off hard disks option is set to 'Never'
Any suggestions? Thanks