Predicate Details

Predicate Details

This page contains a form to view and edit all properties of a predicate, including scoped overrides and the evaluation expressions used by the background engine.

Predicate detail page Edit form for the High CPU Utilization predicate, including scope, expressions, actions, and a result preview

Predicate form

  • Name: the predicate’s internal name. In the screenshot, the display title is High CPU Utilization and the name is cpu_high.
  • Severity: choose the severity for this predicate, or leave it at Default to inherit the shared value.

Scope controls

  • Server Tag: apply this predicate only to servers that have the selected tag.
  • Server Group: limit the predicate to servers belonging to a specific group.
  • Server: target a single SQL instance for this override.
  • Database: restrict the predicate to a particular database.
  • Object: restrict the predicate to a specific object (for example, a file, table, or index).
  • Use the scope controls to create a scoped override; leaving a field empty makes the override less specific (broader).

Editable expressions and fields

  • Evaluation Expression: the boolean expression the engine evaluates. The screenshot uses Actual < Expected. Set this to a valid expression supported by the engine.
  • Expected Expression: the expected value or expression to compare against. This may be a constant (the screenshot uses 90), a computed expression, or one of the available properties of the object being checked.
  • Actual Expression: the expression that yields the measured value to be evaluated (the screenshot uses avg_sqlserver_cpu).
  • Property Name: the logical name used to identify the property in UIs and reports. It maps the actual expression to a friendly identifier and can be used by other parts of the system to reference this value (for example in charts or exported data).
  • Filter Expression: an optional expression that narrows the set of objects the predicate applies to. Use it to include or exclude specific objects so the check only runs against matching items (for example: database_name = ‘X’ AND file_type = ’log’).

Preview and actions

  • Refresh preview evaluates the current predicate configuration and refreshes the result preview.
  • Save applies the changes; Cancel exits without saving. The Info button provides additional guidance about predicate expressions.
  • The Predicate Result Preview shows how the predicate evaluates across matching servers. It displays the result count and a search field above a table with outcome, server, database, object, and expected/actual values; scroll horizontally to see additional columns.

Behavior and helpers

  • Save applies the changes and creates or updates an override for the selected scope. Changing any property (including disabling) counts as an override.