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.