The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Purging old data from the database used by VirtualCenter 2.x (1000125)
VirtualCenter stores tasks, event, and performance data in the VirtualCenter database. Over time, data collection results in growth of the database files and a mechanism is needed to shrink these files.
VirtualCenter 2.x does not have a feature to purge or shrink old records from the database. For more information on shrinking databases after running the scripts provided in this article, see:
There are two variations of this solution, one for each of the supported vCenter database platforms, Oracle and Microsoft SQL Server. The Oracle version of the scripts are not combined. When you extract the scripts, run the version of the script for the version of VirtualCenter that is in use.
The attached scripts support purging the data from VirtualCenter 2.0 and VirtualCenter 2.5.
Note: Do not run the scripts attached to this article against a vCenter Server 4.x or 5.0 database. For information about purging data in vCenter Server 4.x or 5.0, see Purging old data from the database used by vCenter Server (1025914).
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.