?
Solved

Reporting Services startup lag

Posted on 2006-05-09
6
Medium Priority
?
373 Views
Last Modified: 2008-03-17
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
0
Comment
Question by:nito8300
  • 3
  • 3
6 Comments
 
LVL 43

Accepted Solution

by:
Eugene Z earned 1000 total points
ID: 16648002
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
 
LVL 9

Author Comment

by:nito8300
ID: 16650795
I just the upgrade, same issue...
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 16653226
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Author Comment

by:nito8300
ID: 16682712
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
 
LVL 9

Author Comment

by:nito8300
ID: 16798913
I got my answer from google.
I changed the DefaultAppPoll Idle time to 0 and that seemed to work.

Thanks
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 16802523
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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question