Custom Alert Not Clearing
The metric is collected in each user database and runs the following query (returning 1 if the database is not encrypted with native TDE). I can test the query on the database in question and it returns the expected value (0) but it seems as if the query is not being re-run (despite being set to run 1/hour) and the alert based on the metrics continues to show as active.
Best Answer
-
Jon_Kirkwood Posts: 424 Silver 5
Hi @josh_stcu
Thank you for reaching out on the Redgate forum regarding your SQL Monitor alert concern.
I am aware of an issue with custom alerts not triggering correctly on this version. My understanding is a fix has been made available in v13.0.54 which should hopefully resolve this.
Are you able to patch your SQL Monitor instance at your earliest convenience and verify if this custom alert is now triggering as you expect?
Download link for v13.0.54 is available here:
https://download.red-gate.com/checkforupdates/SQLMonitorWeb/SQLMonitorWeb_13.0.54.2514.exe
Jon Kirkwood | Technical Support Engineer | Redgate Software
Answers