Can you suppress specific alerts on a server as opposed to suppressing all alerts for a given time?
kbosshoosier
Posts: 2 New member
I have a window of time on one server (Microsoft SQL Server) where I want to suppress the unhealthy AG alert but I don't want to suppress any other alert as they would be legitimate. I looked at the alert suppression screen and it doesn't appear I have that option....I was hoping it was just not obvious?
Tagged:
Best Answer
-
Kurt_M Posts: 192 Silver 1Hi @kbosshoosier
Unfortunately, the suppression feature we have in SQL Monitor only supports the ability to supress all alerts, or performance and custom metric alert types. There isn't currently a feature where you can only suppress one certain type of alert I'm afraid.
However, you may be able to leverage the SQL Monitor API into doing something like what you're after. In the example scripts we have, there is one to disable an alert. You could modify this to change it to whatever alert you'd like and since it would be a PowerShell script, you could have it run on any schedule you'd like.
https://documentation.red-gate.com/sm/api
Kind regards,
Kurt McCormick
Product Support Engineer, RedgateNeed help? Take a look at our Help Center