4 Replies Latest reply on Mar 31, 2010 8:30 AM by scottd

    Some large tables in SQL

    Spiky

      my database is 25gig,  so been looking through and here are few of the large ones, is there any way to reduce these?  is 25gig  a bit large?

      my system size is

      Network Elements5019
      Nodes744
      Interfaces4215
      Volumes60
      Network Elements5019
      Nodes744
      Interfaces4215
      Volumes60
      Network Elements5019
      Nodes744
      Interfaces4215
      Volumes60

       
      Network Elements 5019
      Nodes 744
      Interfaces 4215
      Volumes 60

      Network Elements5019
      Nodes744
      Interfaces4215
      Volumes60

      Retain Detail Stats 60 Days
      Retain Hourly Stats 120 Days
      Retain Daily Stats 360 Days
      Retain Events 120 Days

       

      interfaceerrors_detail
       
      data space 1.8gig
      index space 3.4gig

       interfacetraffic_detail
       
      data space 5.5gig
      index space 4.2 gig

       responsetime_detail

      data space 1.1 gig
      index 3.2 gig