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