"Top Queries" is missing some queries?
jbrune
Posts: 13 Bronze 1
We have a trace on our server to catch long running queries. One of the queries it caught ran for 60 seconds. I checked SQL Monitor for the time the long query occurred, ordered by duration, show as totals, but I don't see the query that took 60 seconds. I see queries that took more and less than 60 seconds, but not the one I'm looking for. Perhaps this is my misunderstanding of what the 'top queries' section represents?
Comments
The Top Queries section isn't a reflection of Long-running queries. This page describes it as
So the other queries you are seeing may be using more resource than that one (I believe if you sort by a different resource it will pick the top 10 queries for using that resource).
I hope this helps!
Kind regards,
Alex
Have you visited our Help Center?