Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS TimeRendering in ExecutionLog view Expand / Collapse
Author
Message
Posted Monday, October 28, 2013 7:14 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 6:06 AM
Points: 96, Visits: 883
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......?
Post #1509166
Posted Tuesday, October 29, 2013 2:19 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:27 AM
Points: 4,432, Visits: 4,155
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


Markus Bohse
Post #1509212
Posted Tuesday, October 29, 2013 2:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 6:06 AM
Points: 96, Visits: 883
Thanks Markus, appreciate that.
Post #1509213
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse