SQL Monitor alerts on SQL alerts

robinw

I am just about to configure some SQL Server Alerts in SSMS on one of my production servers (detailed here: https://www.mssqltips.com/sqlservertip/3384/configuring-critical-sql-server-alerts/)

Is there any way I can get these to alert in SQL Monitor (with or without configuring via SSMS)?

Thanks in advance.

Robin.

Eddie D

Hi Robin
Thank you for your forum post.
The full list of available alerts for SQL Monitor can be found here in the SQL Monitor help documentation

If you are looking to monitor and be alerted on something that SQL Monitor, by default, does not generate an alert upon.  You can create a custom metric, where you add your own T-SQL query.  Further information is in the help documentation:

• Creating custom metrics and alerts.
• Editing custom metrics and alerts.

Many Thanks
Eddie

robinw

Hi

Having a bit of a dig around, I found the alert I was looking for:

The SQL Server Error log alert with severity threshold metric. That did the job for me.

Thanks.