3 Replies Latest reply on Apr 9, 2014 4:49 PM by Jfrazier

    Orion Database; Growing Pains

    ctmidnight

      Greetings;

      In the ongoing quest to maintain some semblance of performance while giving the customer what they want from Orion, I'm trying to determine where to focus attention on reducing data retention settings to reduce database table size.

       

      My question is: How do these stack up against "best practices" for these table sizes?

       

      Of interest is the result from a quick query on one of our largest instances of Orion to report row count by table.

      We have several tables in excess of 200 million rows, and I'm looking to see if we have hit/exceeded best practices with these:

       

      TableNameRowCnt
      dbo.CustomPollerStatistics_Detail708318044
      dbo.APM_ComponentStatus_Detail406670939
      dbo.InterfaceTraffic_Detail380014034
      dbo.InterfaceErrors_Detail368605138
      dbo.InterfaceAvailability_Detail351631973
      dbo.APM_PortEvidence_Detail295944364
      dbo.APM_HardwareItem_Detail291309472
      dbo.ResponseTime_Detail268128758
      dbo.CPUMultiLoad_Detail260749997
      dbo.SysLog246034077
      dbo.APM_ProcessEvidence_Detail234906378
      dbo.VolumeUsage_Detail220852389

       

      Some current retention settings on this instance:

      Audit Trails Retention: 365 Days

      Detailed Stats Retention: 60 Days

      Hourly Stats Retention: 90 Days

      Daily Stats Retention: 730 Days

      Baseline Data Collection Duration: 7 Days

      Detailed Int Availability Stats Retention: 60 Days

      Hourly Int Availability Stats Retention: 90 Days

      Daily Int Availability Stats Retention: 730 Days

      Detailed Wireless Stats Retention: 60 Days

      Hourly Wireless Stats Retention: 90 Days

      Daily Wireless Stats Retention: 730 Days

      Detailed UnDP Stats Retention: 60 Days

      Hourly  UnDP Stats Retention: 90 Days

      Daily UnDP Stats Retention: 730 Days

      Events Retention: 120 Days

      Syslog Messages Retention: 1 Day

      Trap Messages Retention: 2 Days