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

Parents
  • Hi Jim,

    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.

    Gita
    Spotlight Support Team

Reply
  • Hi Jim,

    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.

    Gita
    Spotlight Support Team

Children
No Data