SSRS Report VERY slow

  • 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?????

  • 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/

  • I haven't tried any format other than html.

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

  • 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/

  • 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