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.
>

Report Model Project: Multiple Data Sources

I have setup a "Report Model Project" with multiple data sources, and
imported tables from each of these into my data source view. When I try to
use the wizard to create a report model I get an error on the "Completing the
Wizard" stage when I click "Run".
An error occurred while executing a command.
Message: Invalid object name 'dbo.<table name>'.
Command:
SELECT COUNT(*) FROM [dbo].[<table name>] t
The <table name> will always relate to the first table it attempts to
process from the secondary (non-primary) data source. I figured this out by
setting up the project from scratch with the opposite data source as primary.
It seems like it is looking in the primary data source for the table that it
should be trying to use the secondary data source to query.
Any help is appreciated. :)A report model can only reference one data source in this release. Data
source views are more flexible than supported by report models.
-Carolyn
"Greg T. Smith" wrote:
> I have setup a "Report Model Project" with multiple data sources, and
> imported tables from each of these into my data source view. When I try to
> use the wizard to create a report model I get an error on the "Completing the
> Wizard" stage when I click "Run".
> An error occurred while executing a command.
> Message: Invalid object name 'dbo.<table name>'.
> Command:
> SELECT COUNT(*) FROM [dbo].[<table name>] t
> The <table name> will always relate to the first table it attempts to
> process from the secondary (non-primary) data source. I figured this out by
> setting up the project from scratch with the opposite data source as primary.
> It seems like it is looking in the primary data source for the table that it
> should be trying to use the secondary data source to query.
> Any help is appreciated. :)