VMware Cloud Community
New_User_999
Contributor
Contributor
Jump to solution

Database size

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?

0 Kudos
1 Solution

Accepted Solutions
MKguy
Virtuoso
Virtuoso
Jump to solution

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

VMware KB: Selective deletion of tasks, events, and historical performance data in vSphere 5.x and 6...

VMware KB: Reducing the size of the vCenter Server database when the rollup scripts take a long time...

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:

https://pubs.vmware.com/vsphere-51/topic/com.vmware.vsphere.vcenterhost.doc/GUID-25800DE4-68E5-41CC-...

-- http://alpacapowered.wordpress.com

View solution in original post

0 Kudos
1 Reply
MKguy
Virtuoso
Virtuoso
Jump to solution

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

VMware KB: Selective deletion of tasks, events, and historical performance data in vSphere 5.x and 6...

VMware KB: Reducing the size of the vCenter Server database when the rollup scripts take a long time...

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:

https://pubs.vmware.com/vsphere-51/topic/com.vmware.vsphere.vcenterhost.doc/GUID-25800DE4-68E5-41CC-...

-- http://alpacapowered.wordpress.com
0 Kudos