User profile for Adam W

Hi Luke, Apologies your question didn't get a prompt reply. You can get a list Alert ID's from: SELECT * FROM [alert].[Alert_Type] To see which alerts are included in 'MaintenanceWindow-AlertsToExclude', execute: SELECT * FROM [RedGateMonitor].[settings].[KeyValuePairs] Adding an alert ID to the SET should stop alerts being generated for that alert type: UPDATE [redgate].[settings].[KeyValuePairs] SET [KeyValue] = '"10","1","5","11","40","16","4","24","12","44","45","41"' WHERE [KeyName] = 'MaintenanceWindow-AlertsToExclude' I'd be grateful if you could let me know if that solves the issue. Thanks Adam / comments

Hi Luke, Apologies your question didn't get a prompt reply. You can get a list Alert ID's from: SELECT * FROM [alert].[Alert_Type] To see which alerts are included in 'MaintenanceWindow-AlertsToExc...

0 votes

Hi, To confirm, this was fixed in Version 7.0.7 - thanks again for raising the issue Adam / comments

Hi, To confirm, this was fixed in Version 7.0.7 - thanks again for raising the issue Adam

0 votes

Thanks for making us aware of this - we're working on a fix now and I'll post an update when it is available. Kind regards Adam / comments

Thanks for making us aware of this - we're working on a fix now and I'll post an update when it is available. Kind regards Adam

0 votes

Hi Kevan, Currently you can only alias the SQL instance, not the host or cluster. We might look to address this if there is more demand (Uservoice would be a good place to suggest it if you would like to see this addressed). Meanwhile I'll add this to our enhancement tracking. Thanks Adam / comments

Hi Kevan, Currently you can only alias the SQL instance, not the host or cluster. We might look to address this if there is more demand (Uservoice would be a good place to suggest it if you would ...

0 votes

Thanks for the explanation, that makes a lot of sense. We are making some more improvements to the reporting so we'll consider something along the lines you suggest. Thanks Adam / comments

Thanks for the explanation, that makes a lot of sense. We are making some more improvements to the reporting so we'll consider something along the lines you suggest. Thanks Adam

0 votes

Hi Kevan, That's right, the tile shows the top 5 queries by total execution time within the selected period. What is most useful for you to see on this particular summary tile? / comments

Hi Kevan, That's right, the tile shows the top 5 queries by total execution time within the selected period. What is most useful for you to see on this particular summary tile?

0 votes

Hi Kev, apologies I missed your reply. That must be a bug. However, the next piece of work we'll tackle is improving the alerts, and that might well include allowing greater control over notifications, as you suggest - I'll update you when I know more (likely next month) / comments

Hi Kev, apologies I missed your reply. That must be a bug. However, the next piece of work we'll tackle is improving the alerts, and that might well include allowing greater control over notificati...

0 votes

Thanks Sijo, it's useful to have this kind of detail as we're considering how to make improvements to alerting. Adam / comments

Thanks Sijo, it's useful to have this kind of detail as we're considering how to make improvements to alerting. Adam

0 votes

Hi Kevan, That's correct - it will prevent all notifications, not just emails. Short term we should reword that, but it would also be really good to know what kind of use cases you had in mind so we can understand the kind of configurability that might be required (e.g. turning off email but allowing Slack notifications etc). Thanks Adam / comments

Hi Kevan, That's correct - it will prevent all notifications, not just emails. Short term we should reword that, but it would also be really good to know what kind of use cases you had in mind so...

0 votes

Hi, That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as the returned value meets the same criteria. It cannot collect multiple values, results containing alphabetic or special characters, or recordsets. https://documentation.red-gate.com/disp ... ine+metric Hope that helps. Thanks Adam / comments

Hi, That's not currently possible with custom metrics. The T-SQL on which the custom metric is based must return a single, numeric scalar or NULL value. It can call a stored procedure, as long as t...

0 votes

How can we help you today?

Adam W

Comments