This message was deleted.

@Nithin B S Have you seen this tutorial - https://signoz.io/docs/tutorial/writing-clickhouse-queries-in-dashboard/ ? Might give you some more ideas

@Nithin B S, why are you using P99 on

signoz_latency_count

? What’s the reasoning? If you are looking for quantile on span metrics duration, you should use

HIST_QANTILE_99

on

signoz_latency_bucket

with group by

service_name

,

le

@Srikanth Chekuri i was trying to create alert for p99 latency with threshold 200ms, i created as u mentioned. alert is working as expected. what should i select for creating alerts for external call duration and db call duration alerts

External and DB calls don’t support the same level of capability https://github.com/SigNoz/signoz-otel-collector/tree/main/processor/signozspanmetricsprocessor#signoz-span-metrics-processor. You can, however, create an alert for average latency duration instead if pXX. Let me know if you would like to use that, and I will share the steps.

ok, please share the steps

It will be

SUM_RATE

of

signoz_external_call_latency_sum

devided by

SUM_RATE

of

signoz_external_call_latency_count

. You will use formula tab for expression.

thanks, its working as expected