• ClearTrace doesn't do it all....grouping the procedures into logical buckets 1-2 seconds, 3-4 seconds, etc. isn't worthless reporting for performance tuning 😉

    Yes it is ...

    1. If you are using sp_executesql to send in dynamic queries, this breakdown will be mostly false positive

    2. If the usage of a SP is higher, ClearTrace will bubble it up based on signature and the rest of the breakdown is just fluff ... worst case scenario just use DMV stats to do the query usage break down.

    3. 1-2 sec, 3-4 sec breakdown is not gonna tell you any story related to performance tuning ... there is more to performance tuning that these breakdowns ...

    Again, i'm mentioning freebies. Ofcourse there are commercial tools that can do more