Add Database instrumentation for apdex with 100ms target, 250ms tolerable
With the merge of !32315 (merged) we can now query Prometheus for performance data on single-node instances.
We should use this to add instrumentation for our key database metrics, in particular our Database Primary Performance Indicator: Query apdex with 100ms target, 250ms tolerable
.
Resulting Prometheus query: (sum(rate(gitlab_sql_duration_seconds_bucket{le="0.1"}[5m])) + sum(rate(gitlab_sql_duration_seconds_bucket{le="0.25"}[5m]))) / 2 / sum(rate(gitlab_sql_duration_seconds_count[5m]))
We will need to add recording rules however to track out to a rolling 7 day average.
We can use this as a reference usage ping: !32315 (merged) as an example, and omnibus-gitlab!4343 (diffs) as an example for adding a recording rule
Edited by Joshua Lambert