The SQL Server Nonfatal Error (severity level lower than 20) alarm becomes active when Spotlight Enterprise detects a new error message that contains one of the following log entries: 'Severity: 17', 'Severity: 18', 'Severity: 19' in the SQL Sever error log.
Edit me

When this alarm is raised view the SQL Server error log around the alarm time. (SQL Server | Error Log drilldown)