SQL 2005 RS Report Manager – load time | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2005 RS Report Manager – load time

Every morning it takes about 30 seconds to load Report Manager.<br />(But of course next loading is within speed of light [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]).<br /><br />Any ideas how to decrease load time?<br />
Are you rebooting the server or client every night>? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Hi Satya & thanks for your quick response! No, I don’t reboot the server every night.
Any other ideas?

Is that happening only on this server or are yu able to reproduce the same on other machines too.
What is the service pack level and any anti-virus or certificate based access on the network? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Well all my laptop & client machines I experience long load times the first time after boot.
I think they behave the same, but I will make a test over the weekend.
The server is: Microsoft SQL Server 2005 – 9.00.3054.00 (X64)
Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) Regards
Olof

After a reboot having such lag time is expected, even I too get the same. But if its for every time then may be something to do with IIS authentication on refresh of Report server too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I tried to solve it by scheduling a job with a nullprovider but that didn’t work since it didn’t use Report Manager. 🙁
Then I see it is a good candidate to feedback onhttp://connect.microsoft.com. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |