This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Query Execution Statistics

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.

Thanks.

Jim

Top Replies

jim.drewe over 5 years ago +1

Hi Gita … thank you for responding.

You mentioned that the drilldown cannot be configured by time interval. What I was wondering was, can we determine what time interval Spotlight is using? That…
jim.drewe over 5 years ago in reply to Gita Sharifi +1

Gita, thank you for the explanation! I really appreciate it. I am fascinated about this topic and did a little more research on how a plan gets aged, or "reaches zero". If memory isn't under…