1.6

Table Of Contents
Table 9-3. Data Purging Scripts (Continued)
Script Description
purgeStatsData
This script removes the vCenter Server performance statistics data that is older than the specified
number of months from the CB_VC_PERFORMANCE_STAT table. The number of months is
specified using the MONTHS_IN_HISTORY parameter in the Oracle script and the
@MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter
appropriately before running the script.
purgeTables
This script is a superset of the purgeCostData, purgeHierarchyData, purgeReportData, and
purgeStatsData scripts. The script removes the cost, hierarchy, report, and vCenter Server
performance statistics related data that is older than the specified number of months. The
number of months is specified using the MONTHS_IN_HISTORY parameter in the Oracle script
and the @MONTHS_IN_HISTORY parameter in the SQL Server script. You can set this parameter
appropriately before running the script.
About the Statistics Data Purging Stored Procedure
vCenter Chargeback schedules a daily roll up of vCenter Server performance statistics data in the vCenter
Chargeback database. The CB_STATS_ROLLUP_PROC stored procedure in the vCenter Chargeback database purges
the vCenter Server performance statistics data that is no longer required. The stored procedure purges data in
the database in batches of 50,000 rows.
You can also manually run this stored procedure. This procedure must be called multiple times till it returns
the value '1', indicating that the roll up is complete.
Chapter 9 Administration Utilities
VMware, Inc. 137