vCenter database size and location affects performance

For any kind of vCenter platform, you need to have a vCenter database, but the question is how does your database size affect your vCenter performance.

If adequate resources are available for your vCenter database, then the supported versions of vCenter databases, such as Oracle and SQL, perform very well. However, you need to understand that a vCenter server task retention policy and higher performance statistics collection settings can increase the database size dramatically, which in turn will affect your vCenter server performance. But, the bundled database of either the vCenter server system or VCSA is a separate matter. The bundled database is intended for the evaluation of the vSphere software or supporting a small infrastructure of up to 20 hosts and 200 VMs. In this case, the vCenter database is collocated with the vCenter server instance. Logging level also affects the performance and size of the vCenter database.

Now when this...