How does the SQL Server Error Log filter function?
The Error Log Filtering view allows selecting which error logs generated by the SQL Server database are to be displayed in the Logs drilldown. The error log alarm increments the error log count for each error log entry that matches one of the strings listed in this view.
Foglight for SQL Server provides a default list of error logs enabled in the scanning, and allows adding, modifying, or disabling error logs from the list.
The settings defined using the Error Log Filtering view affect the following alarms: SQL Agent Error Log Summary, SQL Server Error Log Summary, SQL Agent Log Informational Error, and SQL Server Log Informational Error.
For details, see the Alarms chapter of the Foglight for SQL Server Reference Guide.
The Error Log Filtering view allows defining the following settings:
As well, please ensure that the Sensitivity setting for the Error Log monitoring is set to view the Warning, Critical, and Fatal alarms. This is described in KB 232091
For all SQL Server versions, the Error Log Filtering view allows defining the following settings:
IMPORTANT: Only messages that are explicitly defined in the Ignore List will not be displayed. Messages that were not added to either the Match or Ignore lists appear under name Other, type SQL Server errors messages and severity Informational. Therefore, ensure that messages that need not be displayed are added to the Ignore List.
To add an error to the Match List:
The entire list of filters displayed on the view can be enabled or disabled by selecting the Enable All or Disable All buttons at the bottom of the screen. Enabling a single filter requires editing it.
To edit a filter: