How bad is your SSRS report performance?

In SSRS, the execution data is stored in a table called ExecutionLogStorage table in ReportServer database. You can view this data using the views provided by SSRS named ExecutionLog3, 2 and ExecutionLog. All these views read the data from same table, with only difference is that they interpret data and give you different views.

Following query will give you data on which report sucks.

use ReportServer
go
-- overall suckers
Select Catalog.Name,
TimeDataRetrieval+TimeProcessing+TimeRendering as TotalTime,
 ExecutionLog.Format, ExecutionLog.[Parameters],  
 ExecutionLog.TimeDataRetrieval,
 ExecutionLog.TimeProcessing, TimeRendering,
 TimeStart, TimeEnd, Status, ByteCount, ExecutionLog.[RowCount]
from  ExecutionLog with (nolock) 
inner join Catalog on Catalog.ItemID= ExecutionLog.ReportID
order by TotalTime DESC

-- Query sucks
Select  Catalog.Name,
TimeDataRetrieval+TimeProcessing+TimeRendering as TotalTime,
 ExecutionLog.Format, ExecutionLog.[Parameters],  
 ExecutionLog.TimeDataRetrieval,
 ExecutionLog.TimeProcessing, TimeRendering,
 TimeStart, TimeEnd, Status, ByteCount, ExecutionLog.[RowCount]
from ExecutionLog with (nolock) 
inner join Catalog on Catalog.ItemID= ExecutionLog.ReportID
order by TimeDataRetrieval DESC

-- SSRS Processing sucks
Select  Catalog.Name,
TimeDataRetrieval+TimeProcessing+TimeRendering as TotalTime,
 ExecutionLog.Format, ExecutionLog.[Parameters],  
 ExecutionLog.TimeDataRetrieval,
 ExecutionLog.TimeProcessing, TimeRendering,
 TimeStart, TimeEnd, Status, ByteCount, ExecutionLog.[RowCount]
from ExecutionLog with (nolock) 
inner join Catalog on Catalog.ItemID= ExecutionLog.ReportID
order by TimeProcessing DESC

-- SSRS Rendering sucks
Select  Catalog.Name,
TimeDataRetrieval+TimeProcessing+TimeRendering as TotalTime,
 ExecutionLog.Format, ExecutionLog.[Parameters],  
 ExecutionLog.TimeDataRetrieval,
 ExecutionLog.TimeProcessing, TimeRendering,
 TimeStart, TimeEnd, Status, ByteCount, ExecutionLog.[RowCount]
from ExecutionLog with (nolock) 
inner join Catalog on Catalog.ItemID= ExecutionLog.ReportID
order by TimeProcessing DESC