SQL Agent Insights:Documentation:Log Viewer Overview
The Log Viewer within SQL Agent Insight is specifically used for viewing the SQL Agent logs of a monitored instance.
Key Sections
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 viewing.
Tool/Action Bar
- The toolbar contains all of the actions one can accomplish from within the log viewer. See below for more detailed information on each action.
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 Column to Fit
- Adjusts the width of all columns in the log to the largest cell in that column.
Column Header Group Drop Area
Main Workspace
Row Message Pane
Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8