sql server reporting services: 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

[quoted text, click to view]