August 23, 2004 at 9:51 am
We've recently installed SP1 for reporting services. Now when we generate reports we're getting intermittent but frequent situations where the report is going to the "Generating Report" hypnotic wheel spinning and then just hangs there for a long time. Usually, if we hit Stop then Refresh (from the IE toolbar, not the Rpt Svcs one) the report appears seconds later.
We've looked at the data and the queries come back in 2-3 seconds and the load on the App Server (mid-range app server) is very low. It seems to be a problem when its time to render the report. Reports are all text based but do have nested drill-downs 7 levels deep that are expandable for a total of 2000-3000 rows on the report. When we do the stop/refresh the data comes up rendered correctly...
We don't seem to be producing any error messages or log events. Anyone have any idea what's going on?
Thanks.
August 24, 2004 at 9:09 am
Well,
I don't have an answer(!) But you've got several variables here, and you might investigate this phenomenon further by exploring individual scenarios one-at-a-time (at least that's how I'd try to attack the problem). For example, investigate:
(1) The number of returned rows: Try switching your query to something that returns a small number of rows (say less than 100 rows or so). Any differences observed?
(2) The number of drill-down levels: try a query that produces a drill down of only 2-3 levels. Any differences observed?
Then try combinations of (1) and (2). You might be able to hone in on the problem more closely.
Good luck.
- john
August 25, 2004 at 3:04 pm
John,
Thanks for your suggestions...I'm able to reproduce the issue sporadically with reports that have far few rows to render and fewer levels of nesting (2 vs. 7) and am sure the data is coming back from the DB very quickly...
Will keep trying.
October 6, 2005 at 6:51 am
I'm trying to find answeres to problems with speed of rpeorting services renderings/formatting. Reports take WAY to long to display when the SQL behind them is relatively speedy. Did you ever isolate anythign that helped with your orignal question? I've been messing with IIS configurations but nothing seems to help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply