OK, I have a report in Reporting Services 2005 backed by SQL Server 2005.
I use some C# code to generate 10 records. Maybe 12 columns. There are only 6500 records in the table.
I record those records to the database and then simply display them. So the Reporting Server isn't doing any calculations or anything intense that I can tell.
The records were created in the DB at 3:57PM today. It's 4:11PM now. It's consistently taking 15 - 30 MINUTES to run.
Now, the server hardware is pretty good (12 gigs, 4 cores, etc). BUT it is under pretty heavy load. So I'm guessing that is a part of the problem.
But is there anything I can do to help speed up this process? It sits on the "Report is being generated" circle forever.
Thanks.
EDIT: I forgot to mention I do have indexes setup on the column RS uses to fetch.