This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Capture a specific error message from SQL Server error logs.

Hi,

I am using SQL cart 5.7.5.10. We have a requirement for capturing a specific error message from sql server error logs. The matching filter is "Begin Stack dump".

Can I use the one of default severity level rules for this purpose.

For eg: Rule: DBSS - SQL Server Fatal Current Process Error (severity level 20)

Can I customize the condition as below for capturing these errors.Please let me know if this will work.

if((alarmSeverity == 20) ||(myAlertLogSnapshotInstance.get("alert_message").contains("Begin Stack dump") {

alarmSeverity = 4;

}

else{

alarmSeverity = 0;

}

Regards,