SQL Server Performance

SQL 2005 RS Report Manager - load time

Discussion in 'SQL Server 2005 Reporting Services' started by OlofW, May 18, 2007.

  1. OlofW New Member

    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 />
  2. satya Moderator

    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.
  3. OlofW New Member

    Hi Satya & thanks for your quick response!

    No, I don't reboot the server every night.
    Any other ideas?
  4. satya Moderator

    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.
  5. OlofW New Member

    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
  6. satya Moderator

    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.
  7. OlofW New Member

    I tried to solve it by scheduling a job with a nullprovider but that didn't work since it didn't use Report Manager. :-(
  8. satya Moderator

    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.

Share This Page