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

ssrs 2008 delay in report - first run Expand / Collapse
Author
Message
Posted Tuesday, November 19, 2013 9:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:10 AM
Points: 138, Visits: 176
There are two server for SSRS.
Prod. and Dev.
Every morning the very first user who runs any report on the Dev. server, it takes a long time for the report to be generated...
But this is not the case in Prod. The very first user in the morning who runs a report does not face a delay as he/she does in Dev.
Do you know the cause of this please?
Thanks
Post #1515662
Posted Wednesday, November 20, 2013 2:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 18, 2014 3:43 AM
Points: 390, Visits: 701
Could be any number of reasons. Is the dev server less powerful than the production one? Are the dev server reports looking at the same database location as the production ones?





I'm on LinkedIn
Post #1515947
Posted Wednesday, November 20, 2013 3:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:10 AM
Points: 138, Visits: 176
yayomayn (11/20/2013)
Could be any number of reasons. Is the dev server less powerful than the production one? Are the dev server reports looking at the same database location as the production ones?

The Dev. server is NOT as powerful as prod.
Post #1515965
Posted Wednesday, November 20, 2013 3:13 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 18, 2014 3:43 AM
Points: 390, Visits: 701
Then that's most probably the issue. SSRS takes up memory for rendering reports aside from the sql server that takes the query.

Have a look at this article about configuring SSRS memory.

Without any more specifics I think your issue is with the difference between the servers. Why are users running reports on a dev server anyway?





I'm on LinkedIn
Post #1515966
Posted Wednesday, November 20, 2013 4:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:10 AM
Points: 138, Visits: 176
yayomayn (11/20/2013)
Then that's most probably the issue. SSRS takes up memory for rendering reports aside from the sql server that takes the query.

Have a look at this article about configuring SSRS memory.

Without any more specifics I think your issue is with the difference between the servers. Why are users running reports on a dev server anyway?

Thanks
Post #1515978
Posted Wednesday, November 20, 2013 4:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:28 AM
Points: 12,208, Visits: 9,174
arkiboys (11/20/2013)
yayomayn (11/20/2013)
Could be any number of reasons. Is the dev server less powerful than the production one? Are the dev server reports looking at the same database location as the production ones?

The Dev. server is NOT as powerful as prod.


It could also be related to caching. Maybe the production server has better caching for its reports.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1515980
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse