Create a Custom Alert from a built in metric

SEarle86

There are a number of metrics available in the Analysis tab. Is there a way I can create a custom alert based on these metrics?

I want to create an alert for when Log Space Used % exceeds a give value. Is there any way I can do this?

I can create a custom metric which works out the Log Space Used % and create an alert from that but this feels like it would be a duplication

Ben_P

Hi Steven,

Thank you for your post.

SQL Monitor doesn't have an in-built alert for Log space used so you would need to set this as a custom metric and then set the alert from there:

 

In case you need it there is an existing custom metric that you can install:

https://sqlmonitormetrics.red-gate.com/percentage-of-free-log-space/ 

SEarle86

Hi Ben,
Thanks for this. Seems a shame to have a duplicate something that is already being captured but it will do what I need

Steve