Size the vCenter Server Database

Size the vCenter Server Database

– The size of your vCenter Database is dependent on how many host you have, have many VM’s you have, and the level of statistics you are using. From within vCenter Server under Administration -> vCenter Server Settings-> Statistics there is a section for Database Size. You can plug in your environments specifics and get a DB size. Also, on VMware’s website there is a Database Sizing Calculator. Currently available is the calculator for vSphere 

VCP5 - Size the vCenter Server database

I looked through much of VMware's documentation and couldnt find any easy calculation on how to size your database (For 4.1 I did find http://www.vmware.com/support/vsphere4/doc/vsp_4x_db_calculator.xls, but didn't find anything similar for 5.0). Because of this, I can only assume they are more concerned with you knowing how to change the DB sizing than they are with how big the DB actually is.

There are 2 settings: Statistics Intervals and Database Retention, both of which are managed in the same method.

1. Open Virtual Center and connect to a vCenter Server
2. On the menu bar, select Administration | vCenter Server Settings
3. In the left pane, select Statistics
1. Here you can change the Statistics Levels and retention for performance data
2. This also allows you to enter the number of hosts and VMs data will be collected from and provides you with an estimated database size
4. In the left pane, select Database Retention Policy
1. Configure the database to discard historical tasks and events as appropriate