• State Suggested Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 59 subscribers
  • Views 6995 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Raise an alert when the uptime of SQL DB instance falls behind a threshold

r_v
over 7 years ago

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

Parents
  • 0 over 7 years ago
    Hi Roshan,

    From my understanding, the DB Up time metric is the amount of time that the SQL Server instance was running during the specified time range.

    If the instance is down, no data collection occurs. Therefore, if this metric value is less than the interval length, the value of this metric reflects only the active portion of the interval.

    John
Reply
  • 0 over 7 years ago
    Hi Roshan,

    From my understanding, the DB Up time metric is the amount of time that the SQL Server instance was running during the specified time range.

    If the instance is down, no data collection occurs. Therefore, if this metric value is less than the interval length, the value of this metric reflects only the active portion of the interval.

    John
Children
No Data