October 28, 2013 at 7:14 pm
I've been trying to find any information on the TimeRendering column within the ExecutionLog view for SSRS.
Does anyone know how TimeRendering is calculated? Is it from the time you click Export to Excel until the spreadsheet shows on your screen or......?
October 29, 2013 at 2:19 am
Philip,
The rendering process in Report Server is the operations the report do to show the report content (paint report items, paint data, pagination,…) on the renderer selected (in this case Excel).
If you set the RS logs to Verbose while you render the report you will get detailed information on all these steps, similiar to this:
reportrendering!ReportServer_0-2!bbc!10/14/2013-12:00:38:: v VERBOSE: RPL object model in use
reportrendering!ReportServer_0-2!bbc!10/14/2013-12:00:38:: v VERBOSE: We paginate the page: 1
reportrendering!ReportServer_0-2!bbc!10/14/2013-12:00:42:: v VERBOSE: We paginate the page: 2
reportrendering!ReportServer_0-2!bbc!10/14/2013-12:00:42:: v VERBOSE: We paginate the page: 3
reportrendering!ReportServer_0-2!bbc!10/14/2013-12:00:42:: v VERBOSE: We paginate the page: 4
reportrendering!ReportServer_0-2!bbc!10/14/2013-12:00:42:: v VERBOSE: We paginate the page: 5
reportrendering!ReportServer_0-2!bbc!10/14/2013-12:00:42:: v VERBOSE: RPL object model in use
And these elements that although they point to the processing operation, it actually charges time on rendering gauge and other objects
processing!ReportServer_0-2!bbc!10/14/2013-12:00:44:: GaugeMapper; GaugePanel has been initialized; 3,9064; 3,9064
processing!ReportServer_0-2!bbc!10/14/2013-12:00:44:: GaugePaint; Starting Paint.; 448,2594; 444,353
processing!ReportServer_0-2!bbc!10/14/2013-12:00:44:: GaugePaint; Start rendering of static elements.; 506,8554; 58,596
processing!ReportServer_0-2!bbc!10/14/2013-12:00:44:: GaugePaint; Rendering of static elements complete.; 518,5746; 11,7192
processing!ReportServer_0-2!bbc!10/14/2013-12:00:44:: GaugePaint; Start rendering of dynamic elements.; 519,5512; 0
processing!ReportServer_0-2!bbc!10/14/2013-12:00:44:: GaugePaint; Rendering of dynamic elements complete.; 716,8244; 197,2732
Finally the process ended with the page creation:
reportrendering!ReportServer_0-2!bbc!10/14/2013-12:00:47:: v VERBOSE: PR-DIAG [Page 2] Page created by Vertical page break
[font="Verdana"]Markus Bohse[/font]
October 29, 2013 at 2:21 am
Thanks Markus, appreciate that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply