{"id":295,"date":"2011-10-21T10:09:49","date_gmt":"2011-10-21T15:09:49","guid":{"rendered":"http:\/\/www.ryanbelanger.com\/?p=295"},"modified":"2011-10-21T10:09:49","modified_gmt":"2011-10-21T15:09:49","slug":"ssrs-report-execution-time","status":"publish","type":"post","link":"https:\/\/ryanbelanger.com\/?p=295","title":{"rendered":"SSRS report execution time"},"content":{"rendered":"<p>This query will list the 100 reports that took the longest time to run today.<\/p>\n<p>You must be connected to the SSRS engine, not the database engine.<\/p>\n<pre>use [ReportServer]\nselect top 100 \ndatediff(s,EL.TimeStart,EL.TimeEnd) as 'Runtime(secs)',\nC.Name, EL.Status, EL.Username, EL.TimeStart, EL.TimeEnd, \nEL.TimeDataRetrieval\/1000 as TimeDataRetrieval, --Time it took to get the data from the datasource\nEL.TimeProcessing\/1000 as TimeProcessing, --Time it took to group, filter, aggregate and subreport\nEL.TimeRendering\/1000 as TimeRendering, --Time it took to render, page, expression evaluation\n(EL.TimeDataRetrieval + EL.TimeProcessing + EL.TimeRendering)\/1000 as TotalRunTime,\nC.Path, EL.Parameters\nfrom dbo.ExecutionLog EL\nInner Join dbo.Catalog C on EL.ReportID=C.ItemID AND C.type=2 --Type=Report\nwhere EL.TimeStart &gt;= DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) --Today\norder by 'Runtime(secs)' desc<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This query will list the 100 reports that took the longest time to run today. You must be connected to the SSRS engine, not the database engine. use [ReportServer] select top 100 datediff(s,EL.TimeStart,EL.TimeEnd) as &#8216;Runtime(secs)&#8217;, C.Name, EL.Status, EL.Username, EL.TimeStart, EL.TimeEnd, EL.TimeDataRetrieval\/1000 as TimeDataRetrieval, &#8211;Time it took to get the data from the datasource EL.TimeProcessing\/1000 as [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-295","post","type-post","status-publish","format-standard","hentry","category-tips"],"_links":{"self":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=295"}],"version-history":[{"count":0,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts\/295\/revisions"}],"wp:attachment":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}