Skip to content
CloudOps
Newsletter
All prompts
AI for Prometheus & Monitoring Difficulty: Advanced ClaudeChatGPT

PromQL Holt-Winters Seasonal Forecasting Prompt

Smooth noisy seasonal metrics and forecast short-term trends with double_exponential_smoothing (Holt-Winters) so alerts account for daily/weekly cycles instead of firing every Monday morning.

Target user
SREs building trend-aware alerts on metrics with strong seasonality
Difficulty
Advanced
Tools
Claude, ChatGPT

The prompt

You are a PromQL forecasting specialist who has built trend-aware alerts that respect daily and weekly business cycles.

I will provide:
- The metric and its natural seasonality (traffic, queue depth, latency)
- A graph or description of the cyclic pattern
- The false-positive alerts I'm trying to eliminate

Your job:

1. **Set expectations honestly** — `double_exponential_smoothing` (formerly `holt_winters`) does smoothing + trend, NOT true seasonal decomposition. Tell me where it helps (smoothing jitter, short-horizon trend) and where it does NOT (it won't learn a weekly cycle on its own). If I truly need seasonality, recommend the `... offset 1w` comparison pattern instead, or an external tool.

2. **The function** — explain the two params: `sf` (smoothing/level factor) and `tf` (trend factor), both in (0,1). Give a starting pair and the intuition: higher `sf` tracks recent values more tightly; higher `tf` reacts to trend faster. Show how to grid-search them against history.

3. **Smoothing for alerts** — wrap a noisy metric so threshold alerts fire on the smoothed value, not on single-sample spikes, and contrast with `avg_over_time` (when each is preferable).

4. **Seasonal-aware alerting without true HW** — the practical pattern: compare `now` to `now offset 1w` (same point last week) with a tolerance band, optionally smoothed. Build the full alert expr with a percentage deviation guard.

5. **Capacity short-horizon trend** — combine smoothing with the trend component to project a near-term value, and state clearly why this is inferior to `predict_linear` for monotonic resource growth.

6. **Pitfalls** — sensitivity to gaps/NaNs, the function needing enough points in the range, instability with bad params, and the rename from `holt_winters` to `double_exponential_smoothing` (feature-flag/version notes).

7. **Validate** — backtest against a known seasonal week: count false positives before/after and confirm real anomalies still fire.

Output: the smoothing/forecast expressions, the seasonal-comparison alert rule, the param-tuning method, and a clear note on the limits of this approach.
Newsletter

Free: the DevOps AI Incident-Triage Cheat Sheet

Subscribe and we’ll send you the one-page cheat sheet — plus weekly AI prompts, automation ideas, and tool reviews for infrastructure engineers. One email a week. No spam, unsubscribe anytime.

  • AI Incident-Triage Cheat Sheet (PDF)
  • Access to 1,603 DevOps AI prompts
  • One practical workflow email per week