10 Replies Latest reply on Jul 30, 2008 8:09 AM by rob.borias

    116GB database insane

      You read it correct 116 GB databse and growing.  Its alarming because wed it was 50 gig, friday 75 gig.  Come in monday morning 116 gig and this is after DB shrinks.


       


      I need to know what to do to get this down.  We run Orion SLX version 9.  What is retaining all this data?

        • Re: 116GB database insane
          tdanner

          Are you a netflow user?

            • Re: 116GB database insane

              Yes we are.

                • Re: 116GB database insane
                  tdanner

                  This query will give you the row counts for all your tables. From there you can follow up on the big ones and see how much space they are taking up in bytes. Then we can talk about how to tune data retention to meet your needs.

                  select t.table_name, i.rows
                  from sysindexes i, information_schema.tables t
                  WHERE i.id = object_id(t.table_name)
                  and i.indid < 2
                  order by table_name

                    • Re: 116GB database insane

                      Here is what we got 


                       


                       


                      Accounts,12
                      ActionDefinitions,42
                      ActiveAlerts,0
                      AlertActions,3
                      AlertDefinitions,14
                      AlertLog,27430
                      Alerts,14
                      AlertStatus,3
                      AlertSuppression,0
                      AlertTestLog,11
                      AlertTests,1
                      AlertTriggerMap,3
                      AlertValueChanges,0
                      APM_Application,42
                      APM_ApplicationStatus_Daily,18
                      APM_ApplicationStatus_Detail,495842
                      APM_ApplicationStatus_Hourly,6431
                      APM_ApplicationsToDelete,0
                      APM_ApplicationTemplate,21
                      APM_BusinessLayer,1
                      APM_Component,83
                      APM_ComponentDataToDelete,0
                      APM_ComponentDefinition,13
                      APM_ComponentDefinitionCategory,4
                      APM_ComponentDefinitionCategoryMembership,28
                      APM_ComponentDefinitionSetting,71
                      APM_ComponentSetting,0
                      APM_ComponentStatus_Daily,1077
                      APM_ComponentStatus_Detail,307788
                      APM_ComponentStatus_Hourly,16400
                      APM_ComponentTemplate,78
                      APM_ComponentTemplateSetting,344
                      APM_Config,3
                      APM_Credentials,2
                      APM_CurrentApplicationStatus,42
                      APM_CurrentComponentStatus,83
                      APM_EventType,9
                      APM_PortEvidence_Daily,513
                      APM_PortEvidence_Detail,126245
                      APM_PortEvidence_Hourly,6800
                      APM_ProcessEvidence_Daily,1143
                      APM_ProcessEvidence_Detail,209848
                      APM_ProcessEvidence_Hourly,10000
                      APM_ResourceEvidence_Daily,0
                      APM_ResourceEvidence_Detail,0
                      APM_ResourceEvidence_Hourly,0
                      CiscoBuffers_Daily,51
                      CiscoBuffers_Detail,6675
                      CiscoBuffers_Hourly,6593
                      ConstituentPorts,19479
                      CPULoad_Daily,1368
                      CPULoad_Detail,323707
                      CPULoad_Hourly,89177
                      CustomPollerAssignment,32
                      CustomPollerEnums,3
                      CustomPollerLabels,0
                      CustomPollerParsers,19
                      CustomPollers,14
                      CustomPollerScratchStatistics,0
                      CustomPollerStatistics_Daily,0
                      CustomPollerStatistics_Detail,0
                      CustomPollerStatistics_Hourly,0
                      CustomPollerStatus,32
                      DeletedCustomPollers,0
                      DeletedInterfaces,0
                      DeletedNodes,0
                      DeletedVolumes,0
                      Engines,1
                      Events,13038
                      EventTypes,59
                      FlowCorrelation,215041
                      FlowEngines,1
                      InterfaceCustomPollerJobs,0
                      InterfaceErrors_Daily,2826
                      InterfaceErrors_Detail,395256
                      InterfaceErrors_Hourly,142737
                      Interfaces,366
                      InterfaceSignalNoise_Daily,0
                      InterfaceSignalNoise_Detail,0
                      InterfaceSignalNoise_Hourly,0
                      InterfaceTraffic_Daily,2838
                      InterfaceTraffic_Detail,396290
                      InterfaceTraffic_Hourly,143034
                      IPAddressGroups,5
                      Limitations,0
                      LimitationTypes,22
                      MenuBars,22
                      MenuItems,37
                      MultiPortApps,7
                      NetFlowAddressToResolve,164950
                      NetFlowCorrelationState,1
                      NetFlowDetail_124,654690
                      NetFlowDetail_125,2810
                      NetFlowDetail_126,166170
                      NetFlowDetail_133,25868
                      NetFlowDetail_144,100858
                      NetFlowDetail_209,0
                      NetFlowDetail_210,0
                      NetFlowDetail_211,2841
                      NetFlowDetail_213,25699
                      NetFlowDetail_214,8730
                      NetFlowDetail_215,33030
                      NetFlowDetail_216,48475
                      NetFlowDetail_217,8948
                      NetFlowDetail_218,23422
                      NetFlowDetail_303,1634
                      NetFlowDetail_336,13227
                      NetFlowDetailState,16
                      NetFlowGlobalSettings,22
                      NetFlowLocks,1
                      NetFlowSearchByAddress,313651
                      NetFlowSearchByPort,8417
                      NetFlowSources,612
                      NetFlowSummary1,911254
                      NetFlowSummary2,2689721
                      NetFlowSummary3,4485423
                      NetflowSummaryState,1
                      NodeCustomPollerJobs,9
                      Nodes,242
                      NPM_ActiveJob,0
                      NPM_JobEngine,1
                      NPM_JobExecutionHistory,119452
                      NPM_ScheduledJob,83
                      NPM_ScheduledJobJournal,1400959
                      Pollers,1530
                      ResourceProperties,115
                      Resources,197
                      ResponseTime_Daily,1387
                      ResponseTime_Detail,1451395
                      ResponseTime_Hourly,92208
                      ServicePorts,4590
                      Settings,40
                      SNMPV3Credentials,0
                      SysLog,0
                      SysLogActions,0
                      SysLogFacilities,24
                      SysLogRules,0
                      SysLogSeverities,8
                      TimeUnits,10
                      TransportProtocols,141
                      TrapActions,0
                      TrapRules,0
                      TrapRulesDetail,0
                      Traps,71083911
                      TrapVarbinds,507201966
                      TypesOfService,22
                      Views,21
                      ViewsByDeviceType,2
                      Volumes,500
                      VolumeUsage_Daily,5230
                      VolumeUsage_Detail,431127
                      VolumeUsage_Hourly,263401
                      WebCommunityStrings,18
                      WebSettings,14
                      WebUserSettings,46