I've got an asp.net web application that allows user to generate reports and view them. The SQL Server 2008 R2 database and report server run on the same database. Running the DB Profiler I can see that the queries take much longer when the reports are generated from the web application than if I run them from the SSRS Report Manager or Visual Studio running on the database server. There is an order of magnitude more reads when the queries run from the web app. Any help understanding what's going would be appreciated.

Hi Mark,

it seems to be an SSRS issue. There is nothing wrong with your report.

Its "normal" that SSRS takes more time to load the first time you access it after a long time of inactivity. The issue is caused by the way how SSRS works and SSRS regularly restarts application domain after specific time period. After the application domain is restarted, then upon first request to the SSRS it needs to load all the settings and it takes quite a long time.

This blog show's an work around for the situation