1 Reply Latest reply on Jul 16, 2019 9:27 AM by mandevil

    DBA\Ignite DB consuming 2 TB Space

    vikasrana

      Hi Team,

       

      We are seeing huge amount of growth in following tables which store execution plan and query text, I would like to check following things:

       

      • Can I check if purging is working\not working?
      • Any way to control the size of the these tables?
      • Implement compression for these tables?

       

         

      Table Nameused_mballocated_mb
      CONSPT_109661636.45661916.07
      CONSS_109177744177771.32
      CONSPT_108161070.73161777.76
      CONSPT_11074593.5575828.57
      CONSS_11073648.273663.07
      CONSS_11269194.9469207.2
      CONSPH_10953880.9554248.95
      CONSW_10948236.5248248.82
      CONSPT_11245744.8850092.51

       

      Regards,

      Vikas Rana

        • Re: DBA\Ignite DB consuming 2 TB Space
          mandevil

          Couple of questions:

          1. What version of DPA are you running?
          2. How many instances are you monitoring?
          3. Any recent upgrades or changes in the environment?
          4. What are your retention settings set to for CLEAN_DAYS_OF_DETAIL? Go to Options -> Advanced Options (under Administration) -> Systems Options tab -> make sure support options is checked -> scroll down to CLEAN_DAYS_OF_DETAIL (default is 30 days)
          5. There used to be an issue with plan bloat, but that had been fixed... but I do see a lot of *SPT* tables showing up which would be SQL Plan Text. What kind of workload do you run and do the applications being monitored use a lot of literals and not parameterized much?