1 Reply Latest reply on Jan 8, 2014 10:21 AM by JoeBidgood

    Database keeps growing, need cleanup

    denniz

      Our EPO database keeps growing, and i'm looking to see if i can cleanup some tables (mostly log records). I've enabled some purge server task within Epo 4.6.6, so many tables are cleaned now.

      But there is one table that draws my attention: dbo.EPOProductSettingValues.

       

      It has a rowcount of 32235, and i'm wondering (looking at the name of the table) if Epo really has 32-thousand different product settings....

      Is there a way to cleanup this table, and with which query?

       

      Also i found some other tables that seem very large. Is it possible to purge some records?

      Here a complete list of our large tables:

       

      TableRowCnt
      dbo.EPOProductSettingValues32345
      dbo.OUIs12550
      dbo.EPOServerEvents10321

       

      Message was edited by: denniz on 1/8/14 5:04:31 AM CST
        • 1. Re: Database keeps growing, need cleanup
          JoeBidgood

          Hi...

           

          This is almost certainly normal. EPOProductSettingValues can have a very large rowcount - it contains every single setting for each product installed on every machine. Please do not, under any circumstances, try to modify this table.

          OUIs contains a list of vendor MAC addresses, and should essentially be static. We update the contents of this table occasionally but it should stay pretty much the same.

          EPOServerEvents contains details of things like pull tasks and replication tasks, as far as I know.

           

          HTH -

           

          Joe