SQL Agent Insights:Documentation:Log Viewer Overview: Difference between revisions
| Line 42: | Line 42: | ||
=== Column Header Group Drop Area === | === 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 Workspace === | === Main Workspace === | ||
Revision as of 03:07, 16 February 2023
|
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
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 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