How to use SQL Sentry Plan Explorer Result filters

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.


PS: love the program!

avatar image By deroby 1 asked Feb 27 at 09:09 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Feb 28 at 01:20 PM

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.

avatar image deroby Feb 28 at 08:53 PM

@Aaron Bertrand, Nice, thanks! (looking forward to the fix =)

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question



asked: Feb 27 at 09:09 PM

Seen: 47 times

Last Updated: Feb 28 at 08:53 PM