CODEWITHSUNDEEP
sql-serverreporting-services
asmgx
asmgx

Reputation: 8054

how to trace SSRS stats

we have a large SSRS 2016 reports list

I would like to monitor these SSRS reports

and by monitor I mean to know

is there a way from the SSRS server allows me to get this stat

or is there any script I can add to the reports to get this stat.

Upvotes: 1

Views: 431

Answers (1)

Harry
Harry

Reputation: 2951

run this against your report server DB

use [ReportServer]
SELECT 
R.Name
,R.ItemID 
, L.TimeDataRetrieval
,L.TimeProcessing 
,L.TimeRendering 
, L.TimeDataRetrieval+L.TimeProcessing+L.TimeRendering AS TotalTime
,L.Format
,L.[Parameters]
,L.username
,L.TimeStart 
,L.TimeEnd
,l.ReportID


,DATEDIFF(SECOND,L.timestart,L.timeend) time_seconds
,r.Path

FROM dbo.ExecutionLog L  

INNER JOIN dbo.Catalog R  
    ON L.ReportID = R.ItemID 
    
WHERE R.Name like  'name of your report'

it will give you everything you have asked for.. comment out the where caluse for all the reports. You have somewhere to start.

Upvotes: 2

Related Questions