2.5
Table Of Contents
- vCenter Chargeback Manager User’s Guide
- Contents
- About the User's Guide
- Introduction to vCenter Chargeback Manager
- Configuring Administration Settings
- Authenticating and Managing Users, Roles, and Permissions
- Resource Based Authorization in vCenter Chargeback Manager
- Permissions Defined in vCenter Chargeback Manager
- Managing Roles
- Managing Users
- vCenter Chargeback Manager User Authentication
- Managing Chargeback Hierarchies
- Creating a Chargeback Hierarchy
- Managing a Chargeback Hierarchy
- View a Chargeback Hierarchy
- Add a vCenter Chargeback Manager Entity
- Add a vCenter Server Entity
- Rename a Chargeback Hierarchy or a Chargeback Entity
- Delete an Entity from the Hierarchy
- Delete a Chargeback Hierarchy
- Assign Attributes
- Move Entities Within a Hierarchy
- Allocate Computing Resource Units for a Chargeback Entity
- Share Virtual Machine Cost
- Backdate a Chargeback Hierarchy
- View Properties of a vCenter Server Entity
- Managing and Configuring vCenter Chargeback Manager Cost Elements
- Generating Reports
- Monitoring System Health
- Administration Utilities
- Index
Table 8-10. 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, and purgeStatsData
scripts. The script removes the cost, hierarchy, 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 Manager schedules a daily roll up of vCenter Server performance statistics data in the
vCenter Chargeback Manager database. The CB_STATS_ROLLUP_PROC stored procedure in the vCenter
Chargeback Manager 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.
vCenter Chargeback Manager User’s Guide
150 VMware, Inc.