sql2008 r2 report execution 2 minutes, report generation 8 min
Hi we have 3-rd party application using sql2008R2 ,reports generated by reporting services and they are slow I trace execution of report with profiler , all sp requested by report complited within 2 minutes ,then report window running for 8 minutes before outputing 2 pages of report , report contain grouping and order by. Is any setting could be checked ? 1. CPU and memory load during execution of report bellow 25% 2. report executed from web server
January 14th, 2011 3:39pm

Use RS execution log. Search reporting services performance on MSDN
Free Windows Admin Tool Kit Click here and download it now
January 14th, 2011 4:21pm

Besides Andy's reply, please refer to Troubleshooting Reports: Report Performance at this link http://msdn.microsoft.com/en-us/library/bb522806.aspx Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
January 18th, 2011 2:55am

thans for reply, I don't have permission to modify 3-prd party code in report bellow is it output of report in log file, no errors library!ReportServer_0-13!8bc!01/18/2011-15:07:45:: Call to GetReportParametersAction(/Reports/Sales/MoveA). library!ReportServer_0-13!874!01/18/2011-15:07:46:: Call to GetReportParametersAction(/Reports/Sales/MoveA). library!ReportServer_0-13!8bc!01/18/2011-15:07:46:: Call to GetReportParametersAction(/Reports/Sales/MoveA). library!ReportServer_0-13!ffc!01/18/2011-15:09:13:: Call to GetReportParametersAction(/Reports/Sales/SalesComp). library!ReportServer_0-13!17b8!01/18/2011-15:09:13:: Call to GetReportParametersAction(/Reports/Sales/SalesComp). library!ReportServer_0-13!ffc!01/18/2011-15:09:13:: Call to GetReportParametersAction(/Reports/Sales/SalesComp). library!ReportServer_0-13!8bc!01/18/2011-15:10:28:: Call to GetReportParametersAction(/Reports/Sales/MoveA). library!ReportServer_0-13!8bc!01/18/2011-15:10:33:: i INFO: RenderForNewSession('/Reports/Sales/MoveA') library!ReportServer_0-13!ffc!01/18/2011-15:11:40:: Call to GetReportParametersAction(/Reports/Sales/SalesComp). library!ReportServer_0-13!ffc!01/18/2011-15:11:48:: i INFO: RenderForNewSession('/Reports/Sales/SalesComp') webserver!ReportServer_0-13!ffc!01/18/2011-15:11:53:: i INFO: Processed report. Report='/Reports/Sales/SalesComp', Stream='' library!WindowsService_15!1790!01/18/2011-15:12:15:: i INFO: Call to CleanBatch() library!WindowsService_15!1790!01/18/2011-15:12:15:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions. library!WindowsService_15!1790!01/18/2011-15:12:15:: i INFO: Call to CleanBatch() ends library!ReportServer_0-13!15c0!01/18/2011-15:12:19:: Call to GetReportParametersAction(/Reports/Sales/SalesComp). library!ReportServer_0-13!ffc!01/18/2011-15:12:20:: Call to GetReportParametersAction(/Reports/Sales/SalesComp). library!ReportServer_0-13!ffc!01/18/2011-15:14:20:: Call to GetReportParametersAction(/Reports/Sales/SalesComp). library!ReportServer_0-13!15c0!01/18/2011-15:14:21:: i INFO: RenderForNewSession('/Reports/Sales/SalesComp') webserver!ReportServer_0-13!8bc!01/18/2011-15:14:40:: i INFO: Processed report. Report='/Reports/Sales/MoveA', Stream=''
Free Windows Admin Tool Kit Click here and download it now
January 18th, 2011 4:24pm

The total time for report execution contains three parts: TimeDataRetrieval/TimeProcessing/TimeRendering, 2 minutes for sp is just TimeDataRetrieval part, so if you have the permission, I would recommend you open the SSMS to see the execution log table/view, then you will know which part the of report execution cost the most part of the time, then follow the link http://msdn.microsoft.com/en-us/library/bb522806.aspx to optimize the report. Since you are using the third part application, you could also get some help from them to optimize the web application. Thanks, Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
January 18th, 2011 10:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics