Open for Voting

Add an "Other" column in the stacked column charts for SQL that can be toggled on/off

Assume I have the option set to the default of displaying the top 15 and I am looking at the chart for a day. Also assume that from 4am to 5am none of those top 15 were executing, but 16 - 25 (for the day) were executing. I would expect to see nothing for that hour, even though I could have significant waits. If we extrapolate that to the opening "last 30 days" view, the chart is only showing stacked columns for each day of the waits for the top 15, hiding waits from everything else during each day.

If that's true, we need an "Other" to display the sum of the rest of the waits for each displayed period. That would let me know that I should drill down to see more detail. Something might be in the top 15 for a day and would show up in a day view that will not currently display at all in the "last 30 days" view. Something might be in the top 15 for an hour and would show up in a hour view that will not currently display at all in the day view. DPA could well be failing to show me something that I would consider to be a significant event or issue.

We need to be able to toggle on "other" to see relative wait times, but then be able to toggle it off to focus on the primary performance hitters.

See Re: Is there any way for DPA to show the unlisted wait times (as an "Other" section, perhaps) ?  for conversation related to this.