Return
-
Title
Can Foglight alert on SQL Server error log or SQL Server agent log events? -
Description
Is there a way to fire an alert with email notification for certain events in the SQL Server error log or agent log?
-
Resolution
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:- DBSS - SQL Agent Error Log Summary,
- DBSS - SQL Server Error Log Summary,
- DBSS - SQL Agent Error Log Message
and the SQL Server Log Informational Error alarms- DBSS - SQL Server Fatal Current Process Error (severity level 20)
- DBSS - SQL Server Fatal Database (dbid) Processes Error (severity level 21)
- DBSS - SQL Server Fatal Database Integrity Suspect Error Error (severity level 23)
- DBSS - SQL Server Fatal Hardware Error (severity level 24)
- DBSS - SQL Server Fatal Table Integrity Error (severity level 22)
- DBSS - SQL Server Nonfatal Error (severity level lower than 20)
-
Additional Information
The DBSS - SQL Server Error Log Count and DBSS - SQL Server Error Log size alarms were removed from the SQL Server cartridge beginning with the 5.6.5 version. The DBSS - SQL Server Error Log Message alarm was replaced with separate severity level alarms beginning with the 5.7.5.1 SQL Server cartridge.