Release 5.0.7.2391 bug

• 
  Hi Crimdon,
  
  Thanks for posting on the Redgate forums.
  
  5.0.7 introduced changes to maintenance window where only performance related metrics are suppressed and not machine alerts.
  
  You can see the list of alerts which are suppressed here https://documentation.red-gate.com/disp ... ce+windows. The maintenance window documentation has also been updated to reflect this change.

  Dan B February 12, 2016 06:02

  - 0 +
• 
  Is there now any way of suppressing email alerts in the maintenance window? This was the main reason I used maintenance windows...

  crimdon February 15, 2016 06:00

  - 0 +
• 
  Crimdon has a good point. We use Maintenance Windows precisely for the case where a machine will be down and may possibly have multiple reboots and we don't want to receive email alerts on it. This change in 5.0.7 leaves us with no way to suppress machine down alerts during maintenance times.

  NCstyle February 16, 2016 10:50

  - 0 +
• 
  Hi,
  
  I understand the change in behaviour does deviate from how you are used to using the product.
  
  I have fed this back to the development team and we are investigating if there is any way people can exclude more alerts. I will give an update on this as soon as I get some further information.

  Dan B February 17, 2016 04:02

  - 0 +
• 
  Hi,
  
  There is a temporary short term solution to this which is to edit the SQL Monitor database to include the alert numbers you want to exclude in the [settings].[KeyValuePairs] table.
  
  UPDATE [redgate].[settings].[KeyValuePairs]
  SET [KeyValue] = '"10","1","5","11","40","16","4","24","12","44","45","41"'
  WHERE [KeyName] = 'MaintenanceWindow-AlertsToExclude'
  
  Adding the alert Id to the SET will stop alerts being generated for that Alert type. You can get the Alet ID's from
  
  SELECT * FROM [alert].[Alert_Type]
  
  The solution is only temporary as changes made in 5.0.x might then overwrite anything you add. Of course you can then re-run the update statement to again contain all the alerts you want to exclude.
  
  For future work the team are investigating adding some UI options to allow you to select alerts you do and don't want to see in maintenance windows to remove this problem.

  Dan B February 17, 2016 06:15

  - 0 +
• 
  This fix works fine from an email perspective but I'd still like an option to suppress the alert completely.

  crimdon February 22, 2016 11:31

  - 0 +
• 
  Hi Crimdon,
  
  Apologies in the delay in coming back to you.
  
  This has been raised with the development team and I will update you when I get a new response.

  Dan B February 26, 2016 07:27

  - 0 +
• 
  Workaround don't work for me in Version 5.0.10.2746.
  - emails will be sent in maintenance hours
  - alerts will popup in maintenance hours

  mschier March 15, 2016 04:03

  - 0 +
• 
  Has this been tested to work in 5.1?

  Rich.Kennedy April 21, 2016 14:42

  - 0 +
• 
  Apologies all for not updating this thread.
  
  This has been tested to work in 5.0.11 upwards, including 5.1.

  Dan B April 22, 2016 04:27

  - 0 +

Add comment

Please sign in to leave a comment.