SQL Server Performance Forum – Threads Archive
SQL Server Reporting Services PerformanceWe 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
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
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
What about other ASPX/applications accesing SQL using IIS? Harsh