2 Replies Latest reply on Nov 18, 2013 1:25 PM by Tracy Rodgers

    Calculation for date of last growth

    Kyle B

      We have some monitoring tables for our databases which log the size of the database on a daily basis. One particular type of database grows and grows until it reaches a certain point, at which point we create new ones. This is not a static point, so I can't do <8TB for example.

       

      So, what I'm trying to get, is the date at which the difference day over day is zero (growth has stopped). This will not ever occur except once the database is no longer used.

       

      I'd like to create a T/F where I can set a parameter that's a date, or calculated field, and color/filter the data based on "Has/hasn't grown in the past year" - in other words, recent vs stale data.

       

      Does this make sense? Please ask questions if I'm not clear. Appreciate any input.