I went looking for this and did not see a blog post so here it is.
If you need to see how long SSRS reports are taking to run use the following code on your SQL Report server:
SELECT ItemPath, UserName, TimeStart,
(timedataretrieval+timeprocessing+timerendering)/1000 RunTimeSeconds
FROM ReportServer.dbo.ExecutionLog3
Repeat as needed! Better yet wire it to a view or SSRS report.
No comments:
Post a Comment