Reporting Services startup lag

Hello,
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
LVL 9
nito8300Asked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
what SQL RS service pack do you have?
There is SP2 available for download:

http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/reporting.mspx
0
 
nito8300Author Commented:
I just the upgrade, same issue...
0
 
Eugene ZCommented:
did you check event viewer?  what is cpu on the box ? do you have sql server installed on the box? antivirus is working fine - can you see if it is configured right?
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
nito8300Author Commented:
Hi. Sorry for the delay. You need SQL Server in order to run Reporting Services. Antivirus is working fine.

<<what is cpu on the box ?>>  not sure what you mean here. I have 4 Inter Xeon Processors (1.4GHz)
0
 
nito8300Author Commented:
I got my answer from google.
I changed the DefaultAppPoll Idle time to 0 and that seemed to work.

Thanks
0
 
Eugene ZCommented:
nito8300
 please clarify why did you gave Grade C?
http://www.experts-exchange.com/help.jsp#hi73

C: Because Experts' reliability are often judged by their grading records, many Experts would like the opportunity to clarify if you have questions about their solutions. If you have given the Expert(s) ample time to respond to your clarification posts and you have responded to each of their posts providing requested information; or if the answers, after clarification, lack finality or do not completely address the issue presented, then a "C" grade is an option. You also have the option here of just asking Community Support to delete the question.
 Remember, the Expert helping you today is probably going to be helping you next time you post a question. Give them a fair chance to earn an 'Excellent!' grade and they'll provide you with some amazing support. It's also true that a "C" is the lowest grade you can give, and the Experts know that -- so use it judiciously.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.