Skip to content

Workload Manager Alerts

Workload Manager (WLM) alerts are triggered when queries exceed resource limits or violate workload management rules. These alerts help ensure system performance, fairness, and stability across competing workloads.

Purpose

WLM policies are defined to protect system resources and prioritize workloads. When a query breaches such a rule (e.g., CPU usage, memory consumption, execution time), an alert is raised.

The severity of the alert reflects the action taken:

  • INFO/WARNING for soft limits (e.g., user notifications)
  • ERROR/CRITICAL for enforced rules (e.g., query termination)

Each alert typically includes:

  • Query ID
  • Rule name
  • Impacted database or user

These alerts are a key indicator of workload contention, misconfiguration, or the need to adjust WLM rules.

Alert Definitions

AlertSeverityTrigger AfterDescriptionThreshold Ref
Query AlertVARIES-This alert is raised when a query violates a WLM rule. The severity reflects the rule impact (e.g., warning or error). Details include the rule name, query ID, and database.