search

IBM / spectrum-protect-sppmon

Monitoring and long-term reporting for IBM Spectrum Protect Plus. Provides a data bridge from SPP to InfluxDB and provides visualization dashboards via Grafana.
Apache License 2.0
13 stars 8 forks source link

Table `vms` has a periodic query duration of 3 min #49

Open NielsKorschinsky opened 3 years ago

NielsKorschinsky commented 3 years ago

grafik

It seems like the --daily job has a ~10 min runtime, of which 3 min are soley for the influxdb request to the vms table. If this is correct and not an mathematic error when generating the statistics, the indices of the vms table should be improved, as well as the kind of data saved and the queried request. There are 6.6k vm's backuped.

NielsKorschinsky commented 3 years ago

These spikes are also caused by the pageSize, though the query time of 3 Min is way too high. I've also seen Dashboards with about 17 Minutes. On default load the preferred time is 30 seconds.

Even when looking at query duration per item, vm's is way too high at > 1 second. This may be caused by a missing SPP-Index, but also by the API-Request parameters.