Date Added: Apr 2010
VMware vCenter Server uses a database to store metadata on the state of a VMware vSphere environment. Performance statistics and their associated stored procedure operations are among the largest and the most resource-intensive components of the vCenter database. Hence, the performance of the vCenter database depends upon the frequency at which one collects performance statistics and the level of detail of the statistics one stores. The purpose of this study is to present the performance results of tests the authors conducted of a vSphere 4.0 environment using Microsoft SQL Server 2008 as the vCenter database. The study measures the amount of time it takes to initiate and run the stored procedures in the vCenter database that periodically perform statistics rollups and purges.