Benchmark and document tail-based sampling performance

[axw]

We have a good benchmarking setup for general apm-server ingest performance, but tail-based sampling is a bit of a blind spot. We have done this manually in the past, but we don't have a framework for repeatable testing of TBS.

Once we have a baseline performance established, we should then add to the public documentation. This should include details about disks used, and what kinds of disks are recommended; and expectations about disk and memory usage in relation to ingest rate and sampling rate, and specifically some guidance on setting tail sampling storage limit. Documentation on TBS performance should probably follow on from #7842.

We will need #7845. Assuming we use apmbench, we will need to enable -rewrite-ids to ensure trace.id and per-trace events are not repeated, which would affect TBS.

Note to whoever works on this:

• We should look at how both disk reads and writes grow with both event ingest rate and sampling rate. Rate of writes is generally proportional to ingest rate, but rate of reads is expected to be proportional to the ingest * sampling rate.
• We should compare Badger v2 (in use at the time of writing this) vs. v4 performance (proposed)

[carsonip]

Adding links for posterity.

We should look at how both disk reads and writes grow with both event ingest rate and sampling rate. Rate of writes is generally proportional to ingest rate, but rate of reads is expected to be proportional to the ingest * sampling rate.

To be more exact, in a multi-apm-server setup, the expectation is that "Rate of writes is generally proportional to local ingest rate", ingest rate local to the apm-server under observation.

On the read side, the expectation is that "rate of reads is proportional to local ingest * sampling rate". However, before fix #13464, apm-server suffers from rate of reads proportional to global ingest * sampling rate, which means unscalable disk IO and memory usage.

We should compare Badger v2 (in use at the time of writing this) vs. v4 performance (proposed)

Related to #11546

[raultorrecilla]

moving it from it-107 to it-108

[carsonip]

9.0 8gb ram, gp2, TBS: https://github.com/elastic/apm-server/actions/runs/13698906719
9.0 8gb ram, nvme, TBS: https://github.com/elastic/apm-server/actions/runs/13698916450
9.0 32gb ram, gp2, TBS: https://github.com/elastic/apm-server/actions/runs/13698922879
9.0 32gb ram, nvme, TBS: https://github.com/elastic/apm-server/actions/runs/13698930437
8.18 8gb ram, gp2, TBS: https://github.com/elastic/apm-server/actions/runs/13698941750
8.18 8gb ram, nvme, TBS: https://github.com/elastic/apm-server/actions/runs/13703287624

WIP:
9.0 8gb ram, gp2, no TBS: https://github.com/elastic/apm-server/actions/runs/13816794103
9.0 8gb ram, nvme, no TBS: https://github.com/elastic/apm-server/actions/runs/13816815136
9.0 32gb ram, gp2, no TBS: https://github.com/elastic/apm-server/actions/runs/13816805698

Will summarize and document the differences once all numbers are ready.