SQL Monitor alerts on SQL alerts

robinw · February 4, 2019 11:52AM

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 · February 5, 2019 12:24PM

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:

Many Thanks
Eddie

robinw · February 8, 2019 12:43PM

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.

SQL Monitor alerts on SQL alerts

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk