In SSRS.ReportServer database, there is executionlog view that has details of reports that were completed (succeeded & failed) , not what is running right now.
In Management Studio, if you connect to Reporting Services, there is Jobs (+) tree, that shows reports running right now, but that does not seem accurate, because..
e.g. SSRS01 (Reporting Server) -> SQL01 (Data Source where report query is run).
On SQL01, I see a spid in sp_who2 with hostname SSRS01 running for past 1 day.
But on SSRS01 Jobs, I don't see it.
Then I killed that spid on SQL01. CPU usage dropped. But I was expecting to see it in executionlog view, with high TimeDataRetreival, or rsProcessingAborted status.
But can't find it.
Then I looked in reporting services LogFiles directory, can't find any thing stand out.
Sometimes, I can't find any spid on data source server, still ReportingServices.exe uses 100% CPU. When I restart the reporting service, cpu goes down to normal..
So, question is : What is best way to find reports that are currently running from the SSRS server?