Musings on Data

A blog for data, apis, and all things Power BI by Lukasz Pawlowski.

September, 2007

  • Musings on Data

    Keeping your report servers awake (or No more waiting for report server to startup)

    • 1 Comments
    Update 5/3/2010: With time and experience, we learn. So of course an easier way exists to do what this blog post states. Just set the Idle Time-out to zero on the Application Pool configuration. Bill Staples gives the UI snapshot of where to make the change here: http://forums.iis.net/t/1148433.aspx HTH. Reporting Services in SQL 2005 is hosted in IIS. IIS has a performance optimization built-in that you cannot disable (AFAIK), which shuts down an application once there is a period of 20 minutes of inactivity. This is governed by the Idle Timeout IIS Metabase property. You can read about this Idle Timeout here: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/b39a8ab9-7331-4bad-a89a-0210aadbd4a7.mspx...
  • Musings on Data

    Scale Testing Reporting Services

    • 1 Comments
    I wanted to provide a quick note on how to scale test Reporting Services. Partially I'm posting this so I don't lose the link :-). Often we are asked how best to scale test Reporting Services and what scale numbers to expect coming from a particular configuration. We always hesitate to promise specific numbers because so much depends on your usage patterns, your reports, the size of your data, and your architecture. To say that N users will always be supported by X hardware is just too much of a simplification. Therefore the guidance we give is based on patterns we have seen in our testing lab. You can see the guidance we gave for SQL Server 2005 Reporting Services here: http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx...
Page 1 of 1 (2 items)