Does Top SQL collected data has minimum duration limitation?

Only queries with duration longer than 5 seconds are captured in Top SQL by default. You can change this threshold via Settings -> SQL Server -> Top SQL -> Collection Settings -> Minimum Duration.

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.

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.

Procedure Stats is a separate collection from Completed Queries. I don't know offhand what the criteria are for what gets captured there.

Procedure Stats is not what you asked about originally, and I would recommend creating a new thread titled appropriately to draw peoples' eyes to that very different question.

Appreciate your answer again.
Yeah that probably what we misunderstood.