Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Speeding up Report Manager Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 10:13 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 7:54 AM
Points: 48, Visits: 164
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.
Post #1435004
Posted Friday, April 5, 2013 2:50 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 612, Visits: 2,146
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.
Post #1439493
Posted Friday, April 5, 2013 3:21 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 7:54 AM
Points: 48, Visits: 164
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.
Post #1439502
Posted Friday, April 5, 2013 3:25 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 612, Visits: 2,146
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).
Post #1439503
Posted Friday, April 5, 2013 3:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 7:54 AM
Points: 48, Visits: 164
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.
Post #1439510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse