report pack for iis - report generation taking long?

I've got this installed and the sample database was working fine. I then
imported about a weeks worth from two iis servers (grew the DB to about 5
GB) and now pulling up any of the default 12 reports takes at least 30
minutes to an hour or longer. Is this normal? The SQL server is a dual
xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
Services SP2.Try to do a select of the same data and see how long it takes...RS will be
slower than that of course - but will not be faster than your select when it
queries the data..
Ensure you have properly indexed tables.
You may also wish to run the query on a schedule and deliver it from cache -
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Joe" <joe@.do.not.email.me> wrote in message
news:%23%234FpU4qFHA.248@.TK2MSFTNGP14.phx.gbl...
> I've got this installed and the sample database was working fine. I then
> imported about a weeks worth from two iis servers (grew the DB to about 5
> GB) and now pulling up any of the default 12 reports takes at least 30
> minutes to an hour or longer. Is this normal? The SQL server is a dual
> xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
> Services SP2.
>