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?
Top Replies
-
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…
-
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…
-
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.
-
-