We are planning to upgrade from SSRS 2008 SP1 to SSRS R2s in our production environment . What we have observed in dev environment is that the report parameters takes longer time to load in R2s compared to 2008 SP1 and the report rendering in R2s also seems to be longer then 2008 SP1. The issue is manageable in Native mode but is more apparent on share point.Has someone else also seen these issues ? Is there a fix to it ? I always thought that R2s would enhance the capability and might enhance performance; right now it seems it dips the performance of report execution.

Hi, Please post the execution info of that report against report server database here so that we could do further research, the query like this: Use ReportServerDB select * from ExecutionLog2 where ReportPath = 'YourReport' the SSRS r2 changes the view to ExecutionLog3. thanks, Jerry

Thanks Jerry. We are good with R2s with respect to performance in our production

Thanks Jerry. We are good with R2s with respect to performance in our production

In addition to Jerry Nee's answer. I would like to include this as well, SSRS 2008 R2 ReportServer database has Executionlog and Executionlog2 views in addition to the new one ExecutionLog3.