Application Reliability Metrics formula

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  January 21, 2010 at 1:12 am

  #209263

  I have table which has outagedate column with dates like below

  outagedate

  2009-12-05 04:21:00:000

  2009-12-06 08:22:00:000

  2009-12-10 01:11:00:000

  2010-01-05 04:11:00:000

  .

  .

  Now i want to use below formula to find the reliability for my application

  Weekly App Reliability = e^(-168/<Mean Time Between outage in hours>)

  can some body help me out to derive this ?

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  January 21, 2010 at 8:36 am

  #1106741

  Dividing into parts to make easier to understand

  1)fist step to get the date difference

  outagedatecolumn outagedatediffcolumn in hours

  date1 date2-date1

  date2 date3-date2

  date3

  2)second step

  get the mean time between outage in hours

  3) use the formula

  Weekly Reliability = e^(-168/<Mean Time Between outages in hours>)

  Any Takers??