vCenter

 View Only
  • 1.  Very large VCI_PACKAGE_LOCALES table (Update Manager database)

    Posted Mar 25, 2013 10:18 AM

    The VCI_PACKAGE_LOCALES table of our update manager database has grown very large, in excess of 3GB.

    What can I do to reduce the size of that table? How can I purge old data? There is an KB arcticle on how to purge old vCenter data, but that article doesn't mention the Update Manager DB.

    Thanks,

    Tom



  • 2.  RE: Very large VCI_PACKAGE_LOCALES table (Update Manager database)

    Posted Jun 13, 2013 09:07 PM

    Hello,

    I cannot find anything on how to purge the update manager database.  I am using SQL express for this right now and needed to purge data myself.  Below is a SQL script i used while logged into the Update manager database.  I have have not had any issues since running it. I basically deleted all entries that have Microsoft in the name.  If you do this i suggest backing up the database first.   

    The below script will delete 30000 rows at a time so if you have simple loggin enabled you will not grow your transaction logs by much.

    WHILE (2 > 1)

    BEGIN

    DELETE top (30000) FROM VCI_PACKAGE_LOCALES

    where DOWNLOADURL like '%microsoft%'

        IF @@ROWCOUNT = 0  -- no more to delete

          BREAK;

        -- 1 second delay loop to allow other processes to "jump in"

        WAITFOR delay '00:00:01'

    END

    GO