Applied to: SQL Agent Insight version 0.23

Insight Log

Everything that happens in an Insight is captured within the log tab. It can get very verbose, however, if there is a problem with an Insight, the log is the first place to investigate.

The Insight log will capture events with a date and time stamp and include the following:

  • Configuration settings loaded and applied.
  • Configuration settings changes including maintenance, long running jobs and notifications.
  • Critical threshold breaches showing their polled value versus the configured threshold.
  • Threshold value changes done via the Insight Configuration.
  • Any communication errors that might happen with the underlying SQL instance.
  • Heartbeat messages.

Search

The Insight log can be very verbose and have many entries. The search functionality is built into the filtering capability of each column within the log. Simply click on the filter icon within the DateTime or Message column header to find the desired data quickly and easily.

Options

There are four (4) options accessible from the Log toolbar located to the left of the log table.

SIZE ALL COLUMNS TO FIT
Adjusts the width of all columns in the log to the largest cell in that column.

COPY CURRENT PAGE OF INSIGHT LOG TO CLIPBOARD
Copies the current viewable page of the log to the Windows clipboard which can then be manipulated or saved in another program.

CLEAR ENTIRE INSIGHT LOG
This option is irreversible and will delete all records in the log. A new record stating that the log window was cleared manually is logged for future reference.

CLEAR ANY / ALL FILTER(S)
When a filter on a column is active, the filter icon in the column header will be solid (filled). Clicking the clear filters button will remove any and all filters from all columns showing all available data in the log.

The Insight Log tab. Everything that happens within an Insight is captured here.
Click to enlarge.