I am attempting to use ignite (DPA) to determine how many times per day a specific stored procedure was executed on a specific database. I can hover over many reports to get this count, but no report seems to exist to tell me over the last 120 days how many times it was executed. Running this report 120 times and creating a report by hand seems like a waste when we have this wonderful tool.
I need to correlate that with another report that tells me every time period where the same server had 99%+ processor utilization.
We need to determine how many concurrent calls to this SProc could occur without pegging SQL.
I've engaged out internal team, but have not been able to identify reports able to provide this information.
