vCenter

 View Only

  • 1.  Virtual Center database is huge

    Posted Feb 25, 2010 03:00 PM

    We have an environment that has 30 hosts and 430 Virtual Servers and the VIM_VCDB database size is over 300GB. We also cannot view historic performance for our Vm's - Performance Data is not available.

    1. Is it me or does the database size seem quite a bit high for this environment? How do I downsize it?

    2. How do I get performance history for my VM's to work?

    thanks



  • 2.  RE: Virtual Center database is huge

    Posted Feb 25, 2010 03:44 PM

    Hello.

    Check out kb 1000125 for info on cleaning up the database.

    Have you ever had performance data, or is this something new?

    Good Luck!



  • 3.  RE: Virtual Center database is huge

    Posted Feb 25, 2010 03:47 PM

    Here are a couple of KB articles which may help you:

    Reducing the size of the VirtualCenter database when the rollup scripts take a long time to run (1007453)

    Purging old data from the database used by vCenter Server (1000125)

    Rick Blythe

    Social Media Specialist

    VMware Inc.



  • 4.  RE: Virtual Center database is huge

    Posted Feb 25, 2010 04:40 PM

    KB 1000125 is useful. However take a local backup of DB from SQL and purge the stats.

    There are known issues reported in vCenter U1 where stats rollup job (specifically the daily job) will continuously run and increase the transaction log history. Note, this issue occurs only with vCenter U1 under specific environments.

    Thanks,,

    Ramesh. Geddam,

    VCP 3&4, MCTS(Hyper-V).

    Please award points, if helpful