Hi,
I would like to raise an alert when the uptime of a SQL db instance falls behind a threshold. I know we have an instance availability rule. But I think we can miss some alerts if the instance goes offline and comes back online within the polling interval. Is there a metric which can give this uptime info?
I found #db_up_time# metric in foglight, but not sure if its the correct metric for this requirement.
Regards,
Roshan