Speeding up Report Manager

  • All of the articles I found deal with modifying IIS to speed up report manager, but I'm running in native mode and have very few options that I can modify.

    When developing on my PC (I'm running against the same database), the reports are extremely fast, nearly instantaneous. However when I run the same reports in report manager, it's slower. Not unusably slow, but where my development environment takes only moments to return a result, Report Manager is taking 3-4 seconds. In our environment those 3-4 seconds add up and begin to matter.

    Im running on a virtual 64-bit Win 2008 R2 SP1 Standard server. I've got 8GB of memory allocated to it and I've given SQL 6 of that. Should I try allocating more memory or taking a little bit away from SQL?

    I'm hoping there might be some configuration changes that I could make to speed things up a bit.

    Thanks in advance.

  • your reports might not actually be faster, just cached. As a test try deleting the .rdl.data files (in the same Dir as the repors) and try running the reports again.

  • That shouldn't be the case if I'm changing my sproc and hitting the refresh button right? My understanding was that hitting refresh discarded all cached data and hit the database again.

  • You'd think that. It was like that in 2005 but for 2008 I find that unless I change a parameter the result set stays cached. I even have a shortcutted batch file that deletes all the .rdl.data files. I got tired of banging my head and never seeing changes so I just force the issue now.

    I've looked online for a solution too. I never did find one(That being said I didn't look too hard).

  • Good to know. In the situation I was posting about though, I remember going as far as changing the report layout and changing paramaters just to be as certain as I could. So I still think the problem is with SSRS, but in the future I'll make to clear the .datas as you suggest to make certain.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply