one main report developed on my workstation contains 10 sub-reports. The execution time on the development box in Visual Studio and the deployed version is about 12-15 seconds. Once the reports were deployed on the production server the execution time is
about 3-4 minutes. I am using SQL 2008 R2 with SP2 recently installed. The reports hit one medium cube and one individual MDX statement is executed in 1 second on both environments (dev and prod).
So if each MDX statement has the same execution time on both envs, what to check on the server side for the difference between 4 min and 15 seconds ?
Thank you for any hint/URL/doc!
Few details about the 2 environments:
- SSRS is installed with SharePoint on the production box and in a standalone mode on the dev box.
The second link mentions one specific property [InteractiveSize] , in my case it is set to 8.5in|11in - I mean the main report, the report contains 10 subreports each one on its on page. What values do you suggest ?
I can analyze the ExecutionLog3 view in SSMS and what I found is the TimeProcessing value is huge on the server box comparing it with the dev box. SSRS process computes something during the TimeProcessing period, how can I tune it ?