SQL: What is Reporting Services doing??
Author: jason
Date: 2014-04-11 16:14:51
Category: Technical

Use the ExecutionLog2 View in the ReportServer database to see what reports are being called and the processing times.





Code

USE ReportServer
SELECT TOP 10
ReportPath
, TimeDataRetrieval [TimeDataRetrieval_ms]
, TimeProcessing [TimeProcessing_ms]
, TimeRendering [TimeRendering_ms]
, ByteCount
, [RowCount]
, TimeStart
FROM ExecutionLog2
ORDER BY TimeDataRetrieval DESC


http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx
http://technet.microsoft.com/en-us/library/ms159110.aspx#bkmk_executionlog3
http://blogs.msdn.com/b/sqlcat/archive/2013/10/30/reporting-services-performance-and-optimization.aspx



jason @ jasonthomasfrance.com - www.masterstationlog.com - copyright 2009