This PR changes all the instances of rate_interval with increases to be rate_interval: for the MSSQL mixin.
Related Issue
I was working on a
use case where customer wants to use the MSSQL integration Dashboards to
visualize their DB stats. If we select the Last 2 days timerange, all
works as expected, see 1st capture. However, with 12h for instance,
there are multiple Panels returning No Data, see 2nd screenshot.
Unfortunately, I was unable to find another environment to reproduce the
issue, except customer instance (which is on steady RRC), also, when
running the NoData panels queries in Explore, I can see the same
symptom. Is there something that could possibly cause this issue or is
it expected due to any particular reason?
Similar behavior in rate/increase panels can be caused by low data flow or infrequent updates for certain metrics. I have not been able to replicate the issue, as that would likely mean having a data flow similar to what the customer has. Their data flow was likely too low, causing the rate/increase aggregations to display 'No data', compounded by the outdated rate_interval usage. I suspect that their data rate increased and caused the panels to be 'fixed'. These changes should alleviate related issues but may not cover every case, especially as the data rate becomes extremely low.
Changes
This PR changes all the instances of
rate_intervalwith increases to berate_interval:for the MSSQL mixin.Related Issue
Similar behavior in rate/increase panels can be caused by low data flow or infrequent updates for certain metrics. I have not been able to replicate the issue, as that would likely mean having a data flow similar to what the customer has. Their data flow was likely too low, causing the rate/increase aggregations to display 'No data', compounded by the outdated
rate_intervalusage. I suspect that their data rate increased and caused the panels to be 'fixed'. These changes should alleviate related issues but may not cover every case, especially as the data rate becomes extremely low.