Reporting Services RDLC Slow Initial Load

  • We've a web application that's using the Reporting Services viewer and an .rdlc file to produce a report of an invoice.

    It's running on SQL Server 2008R2 database and retrieving its data using efficient stored procedures.

    There's not a lot of data for one invoice.

    Our users are complaining that sometimes the wait for the report is too long.

    I've tested it and occasionally it takes 30 seconds to produce the report.

    Then if I immediately produce the same report with different parameters and it'll take < 5 seconds.

    The problem isn't with the data retrieval, I've monitored it in firebug and the .aspx Report Viewer form takes 5.27s the 1st time, 787ms thereafter.

    I've searched elsewhere without luck, thought I'd ask the experts if you've any idea how to speed this initial start up.


    Kindest Regards,

    Chris Clarke

  • Chris Clarke-296861 (1/19/2013)


    We've a web application that's using the Reporting Services viewer and an .rdlc file to produce a report of an invoice.

    It's running on SQL Server 2008R2 database and retrieving its data using efficient stored procedures.

    There's not a lot of data for one invoice.

    Our users are complaining that sometimes the wait for the report is too long.

    I've tested it and occasionally it takes 30 seconds to produce the report.

    Then if I immediately produce the same report with different parameters and it'll take < 5 seconds.

    The problem isn't with the data retrieval, I've monitored it in firebug and the .aspx Report Viewer form takes 5.27s the 1st time, 787ms thereafter.

    I've searched elsewhere without luck, thought I'd ask the experts if you've any idea how to speed this initial start up.

    Is the initial slowness waiting for the reporting server to "spin up to speed"? Once it's going, performance is fine? Take a look at:

    http://www.mssqltips.com/sqlservertip/2197/how-to-speed-up-ms-sql-server-reporting-services-ssrs-on-first-run/ or

    http://sql-sudhir.blogspot.com/2009/10/speed-up-reports-in-sql-server.html

    HTH,

    Rob

  • I understand what you're saying but these links are talking about the SQL Services Report Server.

    But we're not using a Report Server, just the Report Viewer with .RDLC files

    (There's no App Pool to configure.)


    Kindest Regards,

    Chris Clarke

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

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