The page in the management portal is limited and was never intended to meet the needs of everyone.
The intention was to make the information readily accessible from SQL, so people could use their favorite reporting tool or dashboard product.
Wrapping SQL in a restful service would be straightforward and there is an example of a REST service that calls a query and generates the JSON for Grafana here
And just to add some more details
I am using the SimpleJson plugin from Grafana Labs as my data source - https://grafana.com/plugins/grafana-simple-json-datasource
The url http://localhost:52777/syshistory/ for that points to the REST application that is implemented by the page I included. When setting up the data source, I only checked ‘Basic Auth’ and added the username and password under ‘Basic Auth Details’.
When i wrote this, i was quoting an already old test report. While it may or may not have been correct at the time, it is certainly not relevant or useful today with modern hardware.
The proper story today is that there is a fixed CPU overhead per byte encrypted or decrypted.
The fractional overhead of a single core would be approximately the data read or write rate in bytes per second divided by the CPU clock speed in hertz.
So on my current 2.8 GHz laptop reading 100 MBs would take roughly 3.6% of one core. Different chips and data rates would give different results.
Log in or create a new account to continue