SQL Server Performance

SQL Server Reporting Services Performance

Discussion in 'SQL Server Reporting Services' started by glennd, May 10, 2004.

  1. glennd New Member

    We have designed and deployed a few reports using MS SQL Server Reporting Services.

    However, we seem to have a serious performance issue.
    when we preview a report through the Designer the output is generated in a second or so, where as when we access the report via the webhttp://servername/Reports/Pages/Report.aspx?ItemPath= ...
    the same report takes about 2 minutes to generate the output using the same parameters.

    Can someone tell where I could start looking?

    Thanks

    Glenn
  2. harsh_sr New Member

    In my experience, report takes more time only once after deploying or after reboot etc( I think its because of JIT compiling of .NET framework it uses) but speed is fast after first run.
    Does your report always delay the execution?

    Is it only the reports that take time or other ASPX pages/application that fetch data from same SQL server on IIS(localhost) also take considerable time? In that case it might be something to do with IIS settings (maybe Shot in the dark)

    HTH
    Harsh
  3. glennd New Member

    The report takes time every time it is executed. I have noticed that the CPU usage goes to a 100% every single time I click view report.

    Glenn
  4. harsh_sr New Member

    What about other ASPX/applications accesing SQL using IIS?

    Harsh

Share This Page