The vCenter DB size is growing continually. We are increasing DB server drive space almost every day. What is the best option here rather than continually increasing the space?
1. Check what tables make up most of the space. I've seen applications like vShield or other 3rd party applications causing a huge amount of events with things like generic login/logout events every second.
You can delete certain stale data manually from the database, see these articles:
VMware KB: Determining where growth is occurring in the VMware vCenter Server database
VMware KB: Purging old data from the database used by VMware vCenter Server
2. Check the vCenter databse statistics collection level. The default level is 1, level 2 includes more data, and level 3 or higher can make the database grow significantly:
1. Check what tables make up most of the space. I've seen applications like vShield or other 3rd party applications causing a huge amount of events with things like generic login/logout events every second.
You can delete certain stale data manually from the database, see these articles:
VMware KB: Determining where growth is occurring in the VMware vCenter Server database
VMware KB: Purging old data from the database used by VMware vCenter Server
2. Check the vCenter databse statistics collection level. The default level is 1, level 2 includes more data, and level 3 or higher can make the database grow significantly: