Applies to: SQL Agent Insight version 0.23

Log Viewer Overview

The log viewer can be dissected into the following areas starting at the left, and then progressing from top to bottom on the right-hand side.

LIST OF AVAILABLE SQL AGENT LOGS

  • Upon first opening the log viewer, SQL Agent Insight determines how many agent log files are on the monitored instance and calculates their sizes. This information is then shown in the left-hand pane of the log viewer allowing one or more to be checked for analysis.

THE TOOLBAR

  • The toolbar contains all of the actions one can accomplish from within the log viewer. See Log Viewer Toolbar Actions below for more detailed information on each action.

COLUMN HEADER GROUP DROP AREA

Located just below the toolbar, the column header group drop area:

  • Allows grouping the data against one or more columns. When grouping is applied, the data is organized into a hierarchical structure based on matching column values and it is sorted in ascending order.
    • To move a column header into the group drop area, left-click drag the desired column header and release in the group drop area.

MAIN DATA GRID

The main workspace for the log viewer resides just below the toolbar. It contains two (2) important sections.

  1. Column headers.
    1. Which can be moved, resized, grouped and filtered.
  2. Individual rows of data.
    1. Which, when selected, will display the message text into the row message window. Additionally, error and warning rows will have a color band shown in the row header, red and yellow respectively.

ROW MESSAGE WINDOW

  • After a log has been loaded, the contents will appear in the main data grid. Subsequently selecting an individual row from the data grid will display its message text within the row message window, located directly below the main data grid.
  • Moving through the rows in the data grid can be done individually by selecting them with a left-mouse button click or post initial selection, by using the up / down arrows key on the keyboard.

Log Viewer Toolbar Actions

The following actions are available when working with your SQL Agent logs:

LOAD SELECTED LOG(S)
Loads the selected log files into the main data grid for viewing.

CANCEL LOADING OF LOG(S)
Cancels the loading of selected logs. This will result in a partial list of data shown in the data grid.

TOGGLE WHETHER ERROR MESSAGES ARE SHOWN
By default this action is enabled. When enabled, log error messages are shown in the data grid. Deselecting this option hides error messages.

TOGGLE WHETHER WARNING MESSAGES ARE SHOWN
By default this action is enabled. When enabled, log warning messages are shown in the data grid. Deselecting this option hides warning messages.

TOGGLE WHETHER INFORMATIONAL MESSAGES ARE SHOWN
By default this action is enabled. When enabled, informational log messages are shown in the data grid. Deselecting this option hides informational messages.

CLEAR ANY / ALL FILTER(S)
Will clear any and all filters set by clicking on the column header filter icon . Additionally, if any of the aforementioned error, warning, or informational toggles have been disabled, doing this action will reset and enable them back to the default.

CLEAR ANY / ALL GROUPINGS
Removes all columns put into the column header group drop area with a single click.

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

The SQL Agent Insight Log Viewer.
Click to enlarge.