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

Custom Alert Not Clearing

On the lastest version (13.0.53.1762) and I've noticed that at least one custom alert is 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.

SELECT COUNT ([d].[name]) AS [UnencryptedDatabases]
FROM [sys].[databases] AS [d]
LEFT OUTER JOIN [sys].[dm_database_encryption_keys] AS [dek] ON [dek].[database_id] = [d].[database_id]
LEFT OUTER JOIN [master].[sys].[certificates] AS [c] ON [dek].[encryptor_thumbprint] = [c].[thumbprint]
WHERE [d].[name] NOT IN ( 'master', 'tempdb', 'model', 'msdb'
  , 'sqlmgmtd', 'localadmin' )
AND  ( [c].[expiry_date] IS NULL
OR [dek].[encryption_state] IN ( 0, 1, 5 ))
AND [d].[name] = DB_NAME ()
AND [d].[state_desc] NOT IN ( 'RESTORING', 'OFFLINE' );

josh_stcu
0

Comments

3 comments

Sort by
  • Jon_Kirkwood

    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
    0
  • josh_stcu
    Looks like I just crossed paths with the update notification: I've got v13.0.54 installed and can confirm it has updated the custom alerts.
    josh_stcu
    0
  • Jon_Kirkwood
    Great news! Glad to hear this patch release resolved this issue.
    Jon_Kirkwood
    0

Add comment

Please sign in to leave a comment.