So, I am using SolarWinds DPA tool to monitor DB activity and obv do things based on that information.
I found a stored procedure that is being used for a SSRS report that has a high number of executions (in the millions) where as the ExecutionLog from the ReportServer shows that the report itslef is utilized maybe 30 or 40 times a day.
Now, I am not that knowledgeable on SSRS, so maybe its a thing I am not aware of?
Can anyone provide any information that might be useful in my endeavor to figure out why there is such a high execution count? Most of googling turns up unrelated results, so maybe I dont know what exactly i should be googling?
In the mean time, I am going to run a trace on the server and see what that shows me.
Thanks in advance.