HI, Is there is any difference in performance wise in between these two versions. i have deployed a report in both the environments. The report is very quick in SSRS 2008 than SSRS 2008 R2. when we are going to new version (Updated version) performance should be increase. but SSRS 2008 R2 is very slow in executing the report. did i miss any config setting while installing SSRS 2008 R2. Pls advice me, your help will be appreciated. Thanks, Rajesh Peethala

I am having the same problem, I believe with 2008 they started rendering that data one page at a time, so if I have a 50 page report it only renders one page, but in 2008 R2 a lot of these same reports now display as 1 to 3 pages even though they are still 50 printable pages in length, so now it has to render upwards of 50 pages as one page. Not sure as to why this is. Will

Hi Rajesh, Please go to the report server database and query the TimeDataRetrieval,TimeProcessing,TimeRendering,Source,RowCount from the ExecutionLog2 if SSRS 2008 and ExecutionLog3 if SSRS 2008 R2 tables for the same report executions here. Here are the description for the columns of the executionlog: •TimeDataRetrieval The number of milliseconds spent interacting with data sources and data extensions for all data sets in the main report and all of its subreports. This value includes: - Time spent opening connections to the data source - Time spent reading data rows from the data extension Note: If a report has multiple data sources/data sets that can be executed in parallel, TimeDataRetrieval contains the duration of the longest DataSet, not the sum of all DataSets durations. If DataSets are executed sequentially, TimeDataRetrieval contains the sum of all DataSet durations. •TimeProcessing The number of milliseconds spent in the processing engine for the request. This value includes: - Report processing bootstrap time - Tablix processing time (e.g. grouping, sorting, filtering, aggregations, subreport processing), but excludes on-demand expression evaluations (e.g. TextBox.Value, Style.*) - ProcessingScalabilityTime (see AdditionalInfo column) •TimeRendering The number of milliseconds spent after the Rendering Object Model is exposed to the rendering extension. This value includes: - Time spent in renderer - Time spent in pagination modules - Time spent in on-demand expression evaluations (e.g. TextBox.Value, Style.*). This is different from prior releases, where TimeProcessing included all expression evaluation. - PaginationScalabilityTime (see AdditionalInfo column) - RenderingScalabilityTime (see AdditionalInfo column) •Source Specifies the type of the execution. It is one of the following values: { Live, Cache, Snapshot, History, AdHoc, Session, Rdce } Source=Cache indicates a cached execution, i.e. dataset queries are not executed live. Source=AdHoc indicates either a dynamically generated report model based drillthrough report, or a Report Builder 2.0 report that is previewed on a client utilizing the report server for processing and rendering. Source=Session indicates a subsequent request within an already established session (e.g. the initial request is to view page 1, and the subsequent request is to export to Excel with the current session state). Source=Rdce indicates a Report Definition Customization Extension (RDCE; a new feature in RS 2008) that can dynamically customize a report definition before it is passed to the processing engine upon report execution. Then, we could analysis this report performance issue in different environment. thanks, Jerry

Somthing like this? 2008 R2 TimeDataRetrieval TimeProcessing TimeRendering Source TimeStart 0 0 0 6 2010-09-29 14:25:29.137 0 399 0 6 2010-09-29 14:25:27.630 7434 3688 5554 1 2010-09-29 14:25:04.783 2008 TimeDataRetrieval TimeProcessing TimeRendering Source TimeStart 0 207 0 6 2010-09-29 14:53:43.813 2342 1799 1813 1 2010-09-29 14:53:35.187

Do you have an idea why the differences in the rowcount values between versions? TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering RowCount timed 7/28/11 1:02 PM 7/28/11 1:03 PM 2597 38849 4962 495149 00:53.3 7/28/11 1:06 PM 7/28/11 1:07 PM 5277 39232 62 990298 00:44.6 The first row is SSRS 2005 and the second is SSRS 2008 R2.Sonya