I’m experiencing an issue with inexperience with SQL and Grafana that I hope you guys can help me out with.
So this is my issue:
I’m trying to display information from a database in a graph panel but the graph panel displays only a part of the data. The panel pulls it data from the database using the following query:
_ ConnectionCount as value,_
_ ServiceName as metric_
_ time ASC"_
I’m using this query 4 times for different tables in my database.
But this query seems not be executed in real-time. In a matter of fact there seems to be a 2 hour delay between my Graph panel and my Database Record.
I have a record that has been injected into my database at 14:54:04.450 and my Graph panel displays this value at timestamp 16:45:04.449. Note that this has nothing to do with Time zones.
Has someone experienced this before?
Is this expected behavior?
Is this an configuration error on my end?
I’m a bit at a loss here.
Looking forward to your reply!
Ubuntu version 16.04.5 LTS
Grafana Version: 5.2.2 (Recently Updated)
Windows 2012 R2
SQL Express Version 2017 with default schema and 2016 compatibility