Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Unanswered: Calculation Sybase DB Availability

    Hi,

    I'm not a DB guy but am in the process of developing a System Health type application for my company. I'd like to be able to report on the availability of our Sybase databases but am struggling to figure out how to develop that metric. Any suggestions out there? We are currently using MOM (microsoft operations manager) to monitor our servers. Is there a way to automatically log this information to a table from Sybase or will I have to monitor when particular services go up and down?

    Thanks in advance
    John

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    You could simply calculate the difference between getdate() and @@boottime.

    Keep updating the record in a table in the database until @@boottime value changes. If it chnages insert a new record.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •