• State Suggested Answer
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 59 subscribers
  • Views 6923 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,

    I spoke to a colleague. He said: The db_up_time is collected from database instance and its value is the difference (DATEDIFF() function) between the startup time of database instance and latest agent collect time.

    Gaston.

Reply
  • 0 over 7 years ago

    Hi Roshan,

    I spoke to a colleague. He said: The db_up_time is collected from database instance and its value is the difference (DATEDIFF() function) between the startup time of database instance and latest agent collect time.

    Gaston.

Children
No Data