Issues

This page lists all issues raised across monitored SQL Server instances.

An issue is created whenever an instance violates one or more rules defined for that instance. Rules are organized as Policies and Predicates: a Policy is a container, and Predicates are the individual tests that are evaluated.

Evaluation engine

• The background evaluation engine runs policies on a schedule:
  • Diagnostic policy: checks instance configuration and best-practice enforcement. Runs once per day.
  • Performance policy: evaluates runtime performance predicates. Runs every 5 minutes.
• If any predicate in a policy fails during evaluation, an issue is created.
• When a previously failing predicate later succeeds, the corresponding issue is automatically closed.

Issue lifecycle

• Issues behave like ticketed findings: they describe a problem and include context, severity, and links to the instance and failing predicate.
• The system avoids duplicate open issues: if an issue is already open for the same predicate/instance, further failing evaluations do not create new issues; the existing issue is kept and updated as needed.

List view and filters

• The Issues page shows the full set of issues; use the controls at the top of the page to filter the list:
  • Open vs All: show only open issues (default) or include closed issues.
  • Instance filter: select one instance from the dropdown.
  • Text filter: search by text in issue title, description or instance name.
  • Flagged only: show only issues marked for follow-up.
• Use the filters to focus on current operational problems or to review historical findings.

Selection and bulk actions

• Next to the filters are controls to Select All or Unselect All issues.
• Each row has a checkbox; when one or more issues are selected the toolbar shows a “Close Selected” button. Use that button to close all selected issues in a single operation.
• Bulk close preserves issue metadata and records the closing actor and time.

Grouped view (by predicate)

• At the top-left of the toolbar a toggle switches the list between the normal individual-issue view and a grouped view organized by predicate.
• In grouped view each row represents a predicate and shows counts of issues for that predicate. Use this view to quickly spot frequently failing predicates and to prioritize policy-level fixes.
• Click a grouped row to expand and see the underlying issues or to jump to a predicate detail page for remediation guidance.

At the top of the page there is a Create new issue button. Use this to manually open an issue that is not produced by policy evaluation — for example, to record a task, an ad-hoc investigation, or an operational incident. The button opens the Create new issue page where you can set the title, description, severity, target instance, flags, and assignee. Manually created issues follow the same lifecycle as policy-generated issues and can be closed when the underlying problem is resolved.

Usage tips

• Start with Open + Flagged to triage urgent problems.
• Use the instance filter to hand off findings to owners or DBAs responsible for a specific host.
• Click an issue to view details, suggested remediation, and evaluation history. Closed issues remain available for audit and trend analysis.

Export and settings

• At the top-right of the page there is an export button that downloads the current list of issues as an Excel file. Use this to share findings with stakeholders who do not use the application or to perform offline analysis.
• The settings (gear) button opens the Policies page. From there you can view and edit Policies and Predicates or adjust parameters and notification settings for each rule.

Usage tips

• Start with Open + Flagged to triage urgent problems.
• Use the instance filter to hand off findings to owners or DBAs responsible for a specific host.
• Click an issue to view details, suggested remediation, and evaluation history. Closed issues remain available for audit and trend analysis.

List behavior and row layout

• The issues list uses infinite scrolling to load more rows as you scroll.
• Each row represents a single issue and contains:
  • Title: typically the predicate name for policy-generated issues. Click the title to open the Issue Detail page.
  • Rule detail: a short explanatory line describing the failing predicate (for example: “free_percent is 11, should be 20”).
  • Instance and object: the target instance and, when applicable, the database or object name referenced by the issue.
• Right-side controls:
  • Created date: timestamp when the issue was opened.
  • Flag icon: toggle to mark the issue as important for follow-up.
• Use the row checkbox to select issues for bulk actions (Select All / Unselect All and Close Selected).