Viewing the results

Results appear as a flat list, sorted by severity, highest first. There's no grouping and no search box: use the filters below to narrow what's shown. The grid has five columns: Severity, Issue, Object Type, Object and Status. Status only appears once you've turned on the Done or Ignored filter, since otherwise every row would read "Not Done".

Filtering

Two dropdown filters sit on the ribbon:

  • Category ticks the checks you want to see by category (Performance, Security, Reliability, Data Integrity, Operational Excellence, Incident).
  • Impact ticks by severity, using the full severity vocabulary (Critical, High, Medium, Low, Info, Pass, Skipped, Failed). In practice Advisor's checks only ever raise Low, Medium or High. The rest of the vocabulary is there for filtering, not because those severities appear in a normal run.

Two toggles alongside the filters control what's visible regardless of category or impact:

  • Done shows findings you've marked as dealt with.
  • Ignored shows findings you've dismissed, whether for now or forever.

Both are off by default, so a fresh run shows only outstanding findings.

Sorting the object tree

The tree beside the results has its own Sort Objects group. The Databases and Tables buttons open a menu to sort by name, by size, or by missing index stats, and an All toggle shows every object even if it has no findings against it.

Acting on a finding

Select a finding to see its available actions, including View Script where a fix exists (see Index Optimisation), plus Done and Ignore. Right-click a row for the same choices, with more detail on what each means:

  • Ignore For Now hides the finding for the rest of this session only. It reappears next time you run Advisor.
  • Ignore Forever is remembered against this server, this check and this object, and is reapplied on every future run until you choose Don't Ignore.
  • Disable Check removes that check from every future run entirely, not only for this object.
  • Done marks a finding as dealt with. Like Ignore For Now, this is only remembered for the current session and isn't saved.

The Script button on the ribbon saves every visible recommendation's SQL, across the whole run, to a single file, so you don't have to open each finding in turn.

Exporting

Export is available to power users and on a dev or beta licence, as Markdown, Word (.docx) or JSON. There is no Excel, CSV or HTML export.