Sue_H,

This is a established environment. but we are facing issue in this month-end only. 
Server A - has reporting services, Report DB and ReportTempDB,
Server B - has source database (transnational), where reports hit to get the data (both server has high end configuration - 128 GB RAM, 32 core CPU).

1. Reports are retrieving the data in Sec. but rendering time is high. We retrieving the information from below query 

SELECT c.Name,ByteCount/1024/1024 as ByteCount_MB, [RowCount],TimeStart,TimeEnd,TimeDataRetrieval/1000/60 TimeDataRetrieval_MIN
,TimeProcessing/1000/60 TimeProcessing_MIN
,TimeRendering/1000/60 TimeRendering_MIN
FROM dbo.ExecutionLog el
INNER JOIN dbo.Catalog c
ON c.ItemID = el.ReportID

WHERE TimeStart BETWEEN '2017-04-27 9:30:48.887' AND '2017-04-27 18:50:48.887'
AND ((TimeProcessing/1000/60)>1 OR (TimeRendering/1000/60) >1)
----AND Name LIKE '%INBEV101%'
ORDER BY
(TimeRendering/1000/60) desc


2. Most of the time, we don't see any request from report server (Server A)  at Server B (Source data server). but still reporting services consume high CPU approx (80-90 +)
3.

."

So Is it possible, we can get information which reports are currently rendering ? and Can we clear rendering queue ?