View Only
  • 1.  Database issues

    Posted Jan 20, 2016 03:30 PM

    The SQL Vcenter Database file VIM_VCDB grows constantly is currently around 8Gb. and the total size of the partition is 10GB. We need to reduce the size of database because the volumen is nearly full. Whats the best way to go about this and prevent vCenter from filling the db again.

  • 2.  RE: Database issues
    Best Answer

    Posted Jan 20, 2016 06:59 PM

    To minimize the database grow you may need change the stats collection level, if it is different than the default, that is 1, change back to 1. If it is already at default stats collection level, you may no have choice, just increase the partition.

    And here is a KB article showing how to shrink the database: VMware KB: Reducing the size of the vCenter Server database when the rollup scripts take a long time to run

    And, you're using the SQL Express database ?

  • 3.  RE: Database issues

    Posted Jan 25, 2016 10:08 AM

    Thanks it was tasks & events data.

  • 4.  RE: Database issues

    Posted Jan 20, 2016 09:52 PM

    In addition to what Richardson mentioned, you can also check the recovery model of the DB of vCenter set to.

    If it is Full Recovery Model, then the DB might grow up exponentially. It is ideally recommended to keep it at Simple Recovery model, unless you are doing some troubleshooting.