15 Replies Latest reply on Nov 2, 2015 10:10 AM by jhouser

    Orion SQL Database Very Large

    jhouser

      Wanted to get some thoughts/suggestions here as I have a case open with Support, but don't seem to be getting anywhere.

       

      Our Orion database is about 277GB and we've only been using SolarWinds for about 3 months now. We've adjusted retention thresholds throughout (NPM, SAM, and etc), run maintenance jobs within SQL, run the SolarWinds Database Maintenance, but the database is still continuing to grow. These 2 tables are the largest culprits:

       

      APM_DynamicEvidence_DetailData

      APM_DynamicEvidence_Detail

       

      Both of these tables are close to 90GB. SolarWinds Support pointed to the SAM retention thresholds, but after adjusting them down to keep only 5 days worth of data and running the maintenance/shrinking, we still haven't gained back any space. We are soon going to be out of disk space on this physical SQL server and I'm hoping to avoid that if possible.

       

      Your help is greatly appreciated!