Comments
Sort by recent activity
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...
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
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
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 ...
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
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?
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...
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
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...
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...