SSRS - Check Report Rendering Time

Here SQL Reporting Server have log our reports processing time in table and We have a View "ExecutionLog3" in SQL Server.

Following Query will gives us the total time (Minutes) taken by the SSRS report to generation.

This Query help us to find out the exact time of every stage.

1. TimeDataRetrieval : Give us time to data retrieval by SQL Server
2. TimeProcessing : Give us time processed to bind with the DataSet.
3. TimeRendering : Give us time to rendering(Formatting) the SSRS report.

use ReportServer

select top 10 

  InstanceName,

  ItemPath,

  UserName,

  CAST((TimeDataRetrieval)as numeric(18,2))/60000 TimeDataRetrieval,

  CAST((TimeProcessing)as numeric(18,2))/60000 TimeProcessing,

  CAST((TimeRendering)as numeric(18,2))/60000 TimeRendering,

  CAST((TimeDataRetrieval+TimeProcessing+TimeRendering)as numeric(18,2))/ 60000 [Total_Time(Minutes)]

 from ExecutionLog3