May 16, 2011 at 8:10 am
I've got a report running in Reporting Services (2008 R2) that is incredibly slow. The report is calling a proc with NO parameters and the proc returns about 450 records. Every time I call the report, it takes several minutes (maybe 5 or more) to render in IE. I've tried restarting the services, running traces to look for blocking (none found) and using FireFox and Chrome (nothing works!!) Also, the proc completes in well under 1 second and the report renders very quick in BIDS. Any ideas?????
May 16, 2011 at 8:35 am
what are you displaying the report as? pdf is very slow at times.
I'd try html first.
I had a problem with slow rendering which was releated to the complexity of the logic in the report which caused the rendering to take a very long time. ( there was lots of logic behind the formatting of the layout based upon the data set(s) )
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 16, 2011 at 8:42 am
I haven't tried any format other than html.
May 16, 2011 at 9:15 am
Think I found the problem. I have guages on my report that are slowing it down. When I removed the guages the report ran fine. I'm really disappointed that would slow the report down because they give it a nice look.
May 16, 2011 at 1:22 pm
hmm that's interesting, I did at one stage try gauges on my dashboards but they took up too much room compared with the normal pie or bar charts - I might revist to check that out. I have 20 charts on my main dashboard so if gauges slow things down I'd really see that.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 16, 2011 at 1:44 pm
Here is an interesting article I found that talks about performance issues related to gauges. http://sqlserverpedia.com/blog/sql-server-bloggers/what%E2%80%99s-up-with-the-slow-ssrs-r2-rendering-in-sharepoint-2010-integrated-mode/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply