SSRS - Report 'spinning'
Posted on 2014-03-28
I am certain that I have seen this problem before, but for the life of me, I can't remember what it was.
A customer of mine is describing a problem with their SSRS performance. In their words, "when we try to execute a report, the system spins for 8 seconds, loads the page, and then spins again to process report".
Their reporting layer is in SharePoint 2013 Farm, which is three servers (web, SSRS and database). Everything is SQL v2012.
Like I said, I feel like I had this problem before. I believe there was a tweak or two for the SSRS configuration, that reduced the spinning, and improved the performance overall.
I am just looking for some good direction from the SSRS Experts. Any information is truly appreciated.