VMware: Purging old data from the database used by VirtualCenter Server (1000125)
VirtualCenter Server stores task, 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. Although there is no feature in the product itself to purge or shrink old records from the database, it is possible to do so manually.
There are two variations of this solution, one for each of the supported VirtualCenter database platforms, Oracle and Microsoft SQL Server.
The attached scripts support purging the data from both VirtualCenter 2.0.x and VirtualCenter 2.5.x.
Note: 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.
For the solution check the source out.
1 thought on “VMware: Purging old data from the database used by VirtualCenter Server (1000125)”
For vSphere: http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&externalId=1025914&sliceId=1&docTypeID=DT_KB_1_1&dialogID=157796088&stateId=0%200%20164167547