Hello Everyone,
We are having an issue where SQL CPU spikes and the Report Service Service is spiked causing short term outages for users until it restores to normal levels.
Is there any report or in Epicor that we can determine what caused the spike in the Reporing Services Server so we can prevent this from occuring again?
You can execute the following against your ReportServer database in SSMS to get the CPU history by minute per report for reports submitted in the last 60 minutes.
--CPU history by minute per report
--shamelessly borrowed from
--https://deibymarcos.wordpress.com/2014/08/25/microsoft-sql-server-reporting-services-ssrs-consumes-100-of-cpu/
select distinct
Name, -- Name of the report
Path, -- Path of the report, where the RDL is located
COUNT(*) calls, -- Number of calls this report has per minute
CONVERT(VARCHAR(19),timestart) minutes, -- Shows you the last 60 minutes and reports that were called in each minute
AVG(timedataretrieval)/100 DB_Time, -- Time spend in Database
AVG(timeprocessing)/100 Processing_Time, -- Time spend in processing the report
AVG(timerendering)/100 Rendering_Time -- Time spend in rendering the report PDF, XLS, etc
from dbo.ExecutionLog A left join dbo.Catalog B
ON A.ReportID = B.itemid
where timestart >= DATEADD(mi, -60, GETDATE()) --Retrieve the information from the reports executed in the last 60 minutes
group by path, name, CONVERT(VARCHAR(19),timestart)
order by CONVERT(VARCHAR(19),timestart) desc