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 Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 10:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:19 PM
Points: 327, Visits: 587
We are migrating our databases to new our new servers and MS SQL Server 2008. Since almost no one is on this server, and jobs are not running yet.. why does it take over a min to pull up SSRS?

http://BIServer.global.loc/ReportS/pages/folder.aspx
Post #1410699
Posted Thursday, January 24, 2013 12:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:16 PM
Points: 13,253, Visits: 11,032
You mean Report Manager? It's normal that it takes a while to load the site for the first time.
Either you see that as "coffee-time", or you can solve it using this article:

How to Speed up MS SQL Server Reporting Services SSRS on First Run




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 #1410934
Posted Thursday, January 24, 2013 2:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
Koen Verbeeck (1/24/2013)
You mean Report Manager? It's normal that it takes a while to load the site for the first time.
Either you see that as "coffee-time", or you can solve it using this article:

How to Speed up MS SQL Server Reporting Services SSRS on First Run


Does that apply to 2008 saying it doesnt run via IIS anymore?

Edit

Doh!!!!!!!!!!!!!!

Read the comments, modify the config file, recycletime property.

Will teach me to comment before reading the topic fully.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1411008
Posted Thursday, January 24, 2013 12:49 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:19 PM
Points: 327, Visits: 587
Thanks. The windows folks have locked me out of that folder, so I have requested the setting to be raised. Of course once we go live, this will likely only become an issue when there is a big break between global time zones and it is a weekend. Since our users are global and will be in in every few hours.
Post #1411307
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse