How to use SQL Sentry Plan Explorer Result filters

deroby 2018-02-27 21:09:19

After capturing the Results I'd like to filter out all items that are less than 500ms.

When I try to set the filter to 'Duration [Is greater than] 500' then it will show me all records where the first character of the duration is 6,7,8 or 9. E.g 60 will show, but 11.345 will not, which makes no sense IMHO.

Is this a bug or am I doing something wrong?

Additionally, is there a way to 'remove' the hierarchy in the grid? E.g. when I sort on statement I'd like all INSERT statements to be shown together without the EXEC's etc surrounding it because they exist in different stored procedures.

Thanks.

PS: love the program!

Aaron Bertrand 2018-02-28 13:20:40
I've filed the filtering issue as a bug (#37889); thanks for reporting. I'm not sure the grid has the capability to remove hierarchy once it's there, but I'll ask my team about it; we have some work against the grid coming up soon.
deroby 2018-02-28 20:53:42
@Aaron Bertrand,
Nice, thanks! (looking forward to the fix =)