Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sergey_B
Starting Member
2 Posts |
 Posted - 2011-03-24 : 10:28:09
|
| I am facing in issue with report processing time on SSRS 2008. It looks like it processes the complete report instead of processing only one page. Whereas according to the article in MSDN, the SSRS report processor should perform processing only for the current page that is viewed by the user: [url]http://msdn.microsoft.com/en-us/library/bb522806(v=SQL.100).aspx#Process[/url] My report just reads data from the pre-populated table and displays them on the quite simple layout. The only nuance is that amount of records in the table is quite big (about 1 million). Layout does not contain any grouping, sorting or complex expressions. Basically, it just displays thousands of pages to user without any processing at all (don’t ask me why, it is just the way it must be).Report execution details:• Record count: 989634• TimeDataRetrieval: 33-83 sec• TimeProcessing: 612-667 sec• TimeRendering: 22-45 sec• SQL Server version: Microsoft SQL Server 2008 (SP2) - 10.0.4266.0 (X64) The numbers above indicate that SSRS processes the complete report instead of one page. I can see it from big TimeProcessing and the fact that navigation to the last page in Report Viewer is rather fast (1-2 seconds). I tried everything that is recommended in the MSDN article above:• I make sure that there are no expressions in the Page Header or Footer that can force all pages to be processed.• I verified that InteractiveHeight is not 0 (it is set to 8.5 inches).• I previewed report in a WinForms Report Viewer and via Report Manager, which I guess are supposed to use a soft-page break renderer, which automatically handles paging.• I don’t use any grouping and aggregate functions in the report layout.• I don’t use any subreports.• KeepTogether property on all Tablix members is set to FALSE.If you have any ideas about how to make SSRS processing report only for the current page (and as a result to show the first page faster), your help will be much appreciated. |
|
|
|
|
|
SSRS 2008 processes report instead of one page