The TSQL Batches and individual SQL Statements are sorted based on "Active Time", with the batches / statements that consumed most active time appearing in the Tops 'n' list (Top 25 , Top 50 and so on).
This behavior is regardless of the dimension chosen; for example, in the "Instance View | TSQL Batches" dimension, a given batch may be third in the list based on "Active Time", but the same batch when viewed from "Instance View | Databases" dimension may be the first in the list, if it is the most "Active Time" consuming batch in that database for the chosen time period.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center