It is obstructive to see an EXCLUDEd SQL show up again, and again, and again, on Hourly and lower Trends pages.
When "I" say "EXCLUDE", I mean "go away until I specifically include you back"
Consider:
- Some "lunatic" fires off a multi-million-row, multi-table-join, query that will only run for 3 HOURS.
- During that time, we need to see the "real" activity on the server.
- We EXCLUDE that duly-labelled nut-job Query.
- We drill down past the Day, and there it is, that sucker is in my face, taking up half the chart, obscuring the real queries.
- And not satisfied with the original idiotic query, they re-code it, ignorantly, to use WITH (NOLOCK) and run the darn thing again!
- So I label it "NutJob2" and now I have 2 of them - because they happened to run in the same hour...
Please, add a simple toggle - "Exclude completely"/"Exclude at High Levels".
And while you are there, PLEASE add "Exclude from Current", because if it runs for 3 hours, it's splatter on my screen until the last moment of the hour since it finished is gone by...
Thanks.
