Description
In the Query Stats and Procedure Stats drill-down history windows, the chart draws a continuous interpolated line between data points. When there are only a few sparse samples, this creates a misleading visual — it looks like a steady trend when really there are just discrete execution points.
Example: A query with 2 executions ~2 minutes apart at ~34,000ms duration shows as a continuous upward line from ~33,950 to ~34,300, implying the query was running the entire time and gradually getting slower. In reality it just executed twice at two discrete points.
Request
For sparse data (few data points spread across a wide time range), the chart should either:
- Show scatter points (dots) instead of lines
- Use a step/bar chart style
- Or at minimum, show prominent markers at data points so the line doesn't dominate the visual
This applies to both the Query Stats History and Procedure Execution History drill-down windows.
Description
In the Query Stats and Procedure Stats drill-down history windows, the chart draws a continuous interpolated line between data points. When there are only a few sparse samples, this creates a misleading visual — it looks like a steady trend when really there are just discrete execution points.
Example: A query with 2 executions ~2 minutes apart at ~34,000ms duration shows as a continuous upward line from ~33,950 to ~34,300, implying the query was running the entire time and gradually getting slower. In reality it just executed twice at two discrete points.
Request
For sparse data (few data points spread across a wide time range), the chart should either:
This applies to both the Query Stats History and Procedure Execution History drill-down windows.