Post reply

Report Manager Performance

  • December 12, 2005 at 2:16 pm

    #170033

    Hi we've been using Reporting Services (2000) for a few months and I'm trying to get things setup correctly

    When running Report Manager on our production web server there is a significant (20sec) delay when you first go to the RS website. After first accessing the site things hum along nicely until the site is inactive for a while then performance drops off for the first hit again. I haven't seen any settings to control this within the Report Manager so I'm assuming this has to do with allocation of resources on the box, or caching of pages.

    The web server is a virtual machine with approx 1.5Gb of RAM assigned, it also runs a couple of other production websites.

    Does anyone know any gotchas with Report Manager performance, or recommend any things to try and improve performance. Such as settings for the IIS Application Pool or RS Services?

    Thanks in advance.

    Kindest Regards,

    Martin

  • December 13, 2005 at 2:39 am

    #609152

    If the report manager is slow to load on Windows 2003 server then you can:-

    1.  Click on "Start | Settings | Control Panel | Administrative tools | Internet Information Services (IIS) Manager"

    2.  Expand the server node then "Application Pools"

    3.  Right click on "DefaultAppPool" and "Properties"

    4.  Click on "Performance"

    5.  Change the "Shutdown worker processes after being idle for (time in minutes)" to 480 (8 hours)

    6.  Click "OK" and exit

    There will still be a delay first time each morning the report server is accessed but this can be fixed by running a dummy report on a schedule at 6am before the users use the system.

    Hope it helps

    Dale

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply