What you will learn in this TP
- Create panels with the query builder
- Write a ClickHouse query
- Create an alert
Introduction #
What you will learn in this section
- Create panels with the query builder
- Write a ClickHouse query
- Create an alert
Context. The team wants to check the health of HotROD every morning and be warned when it degrades.
Prerequisites: previous lab completed · Estimated time: 40 min
Monitor a service with SigNoz.Setup #
Guided steps, with their solutions.
1. Query builder panel
Why? The query builder saves you writing SQL for everyday needs.
Create a “HotROD” dashboard with a Time series panel: number of spans per service (source Traces, aggregation Count, group byserviceName).2. ClickHouse panel
Why? SQL allows calculations that the query builder does not offer.
Explore the schema, then add a Table panel that calculates p95 latency per operation.3. Create an alert
Why? A latency alert warns you before users complain.
Create a metric alert: p95 latency of thefrontendservice above 800 ms for 5 minutes, with a test webhook channel (for example webhook.site).4. Trigger the alert
Why? You validate an alert by watching it fire.
Generate heavy load on HotROD to increase latency and follow the alert's state.
Difficulty level : ●●●○○ (3/5)
My progress
Sign in to track your progress and take notes. Sign in
💬 Questions about this lesson
No questions yet: be the first to ask for help or share your configuration.
Recommended Articles
Using SigNoz: APM, traces, logs, dashboards and alerts
Use SigNoz day to day: APM view of services, traces and logs explorers, query builder, ClickHouse...
SigNoz, ClickStack and ClickHouse best practices for observability
Best practices for observability on ClickHouse with SigNoz or ClickStack: OpenTelemetry instrumen...
SigNoz: architecture and installation
SigNoz components (OpenTelemetry collector, ClickHouse, query service, interface, alerts), instal...
Observability on ClickHouse: why a columnar database changes the game
Why more and more observability platforms store logs, traces and metrics in ClickHouse: columnar ...
Alerts and dashboards in ClickStack
Building charts and dashboards in ClickStack, creating alerts on a search or a chart, sending the...
Operating an observability platform on ClickHouse and choosing a tool
Operate ClickHouse for telemetry (replication, disks, merges, object storage, monitoring) and com...
Using Faro data: queries, dashboards, alerts and GDPR
Query Faro data in Loki (Web Vitals, errors, events), build dashboards and alerts, and comply wit...
Datadog APM and OpenTelemetry: traces, services and correlation with logs
Instrument applications for Datadog APM (dd-trace, single step instrumentation, OpenTelemetry), u...
DQL in practice: exploring logs and events, notebooks, dashboards and performance
Use the Dynatrace Query Language day to day: explore logs and events, chain commands, parse field...