SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Speeding up Report Manager


Speeding up Report Manager

Author
Message
Bad_Karma
Bad_Karma
SSC Veteran
SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)

Group: General Forum Members
Points: 227 Visits: 190
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.
Steven.Howes
Steven.Howes
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1648 Visits: 2354
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.
Bad_Karma
Bad_Karma
SSC Veteran
SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)

Group: General Forum Members
Points: 227 Visits: 190
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.
Steven.Howes
Steven.Howes
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1648 Visits: 2354
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).
Bad_Karma
Bad_Karma
SSC Veteran
SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)SSC Veteran (227 reputation)

Group: General Forum Members
Points: 227 Visits: 190
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search