How can we help you today? How can we help you today?

SQL Monitor alerts on SQL alerts

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.
robinw
0

Comments

2 comments

Sort by
  • 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:
    Many Thanks
    Eddie
    Eddie D
    0
  • 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.
    robinw
    0

Add comment

Please sign in to leave a comment.