"Top Queries" is missing some queries?

jbrunejbrune Posts: 13 Bronze 1
edited July 12, 2016 11:15AM in SQL Monitor Previous Versions
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

  • Alex BAlex B Posts: 1,131 Diamond 4
    Hi jbrune,

    The Top Queries section isn't a reflection of Long-running queries. This page describes it as
    The Top queries tables shows the queries that used the most resource during the selected time period. The data is updated automatically every 60 seconds.

    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.