The SQL Server Error Log alert indicates that specific text appeared in the SQL Server log. You can customize which text triggers the alert. You can also customize the severity of the alert based on the frequency of occurrence.
The default settings are:
- 11 - Warning
- 18 - Critical
Use a size limit on your SQL Server Error log
SQLdm allows you to limit the size of your SQL Server Error log to help improve response time and avoid using unnecessary space on your server. For additional information and steps on setting this limit, see Configure text and expression alerts.