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.
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...
And, you're using the SQL Express database ?
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...
And, you're using the SQL Express database ?
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.
Suhas
Thanks it was tasks & events data.