Does Top SQL collected data has minimum duration limitation?

Could someone help me to understand what SQL Sentry collected Top SQL (completed queries), does the service only collect something execution elapse over particular threshold?

Parents Reply
  • Thanks for the comments.

    We configured SQL Sentry Collection Setting by default, which is elapse time over 5 seconds.

    But what "misleading" our people, that in Procedure Stats tab, we could see AVG Duration under 5 seconds.

    After searching for the Procedure Stats tab background process, it seems extract elapse time from ProcedureStatsHistory table, could you also please advise how this table data being populated for total elapse time?

    Great appreciate if you could resolve our confusion.