Hi. I have a question about Query Execution Statistics in Spotlight on SQL Server Enterprise, version 12.1.0. What I am wondering about is how far back does the "last 50" statistics go? That is, is it four hours, 24 hours. or forever? I don't really believe it is more than 24 hours because the "Last Execution Time" is usually from last night when batch was run. So another part of the question is whether I can influence the time interval for the report.
If you look at my screen capture below, the Query Execution Stats drilldown lists top 50 sessions by the Total Worker Time metric. You can configure the drilldown to see more sessions by increasing the top number or change the measured metric by choosing a different value from the 'By' dropdown list. This drilldown can't be configured by a time interval. Hope that helps.
GitaSpotlight Support Team