I've been working on various monitoring improvements using grafana and influx.
I'm wondering if anyone has tackled something that provides detail on "top queries" or something more than a simple time series metric? This is one area I haven't been able to figure out a good solution too, but would resolve a big gap between grafana as a monitoring tool for me compared to some commercial equivalents.
I know how to get data pushed via polling perfmon/and various other ways, but not sure of the way you might suggest approaching this, if it is even possible.
This also sort of relates to "top processes" on a server at particular moment. I can capture these via powershell and push, but not sure of the best schema design to do this. Any tips are welcome!