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
                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