495

SQL Server SSRS: Get processing and rendering time of an report

SQL Server SSRS: Get processing and rendering time of an report

The SSRS Server sotres some usefull information about the processiong of an report request. This inormation could be accessed with following query:

select 
	CONVERT(varchar, DATEADD(ms, l.TimeProcessing , 0), 114)	as time_processing_human,
	CONVERT(varchar, DATEADD(ms, l.TimeRendering  , 0) , 114)	as time_rendering_human,
	l.* 
from YourReportServerDatabase..ExecutionLog3 as l 
order by l.TimeProcessing DESC 

In the example above I'm converting the first two columns from millisecond to human readable string HH:MM:SS

Comments (0)


This thread has been closed from taking new comments.