Tuesday, August 25, 2015

SQL Reporting Services report run times

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