6.7

(SELECT t.table_name seg_name, t.table_name tname,
'TABLE' seg_type
FROM user_tables t
UNION
SELECT i.index_name, i.table_name,
'INDEX'
FROM user_indexes i
) ti
WHERE
ti.tname LIKE 'VPX_SAMPLE_TIME%'
OR ti.tname LIKE 'VPX_TOPN%'
OR ti.tname LIKE 'VPX_TASK%'
OR ti.tname LIKE 'VPX_EVENT%'
OR ti.tname LIKE 'VPX_HIST_STAT%');
The script returns the statistics storage size in MB.
5 Calculate the minimum storage size for the new appliance that you are going to deploy during the
upgrade.
a The size of the database (/storage/db) partition of the embedded PostgreSQL database must
be at least twice the size of the Oracle core table returned in Step 2.
b The size of the statistics, events, alarms, and tasks (/storage/seat) partition of the embedded
PostgreSQL database must be at least twice the sum of the sizes of the Oracle events and tasks
and statistics tables returned in Step 3 and Step 4.
For example, if the Oracle core table is 100 MB, the events and tasks table is 1,000 MB, and the
statistics table is 2,000 MB, then the Postgres /storage/db partition must be at least 200 MB and
the /storage/seat partition must be at least 6,000 MB.
Determine the Microsoft SQL Server Database Size and the
Storage Size for the New Appliance
Before upgrading a vCenter Server Appliance or migrating a vCenter Server on Windows that uses an
external Microsoft SQL Server database, you must determine the size of the existing database. Based on
the size of the existing database, you can calculate the minimum storage size for the new appliance so
that the embedded PostgreSQL database can successfully assume the data from the old database with
enough free disk space after the upgrade.
You run scripts to determine the Microsoft SQL Server core table size, the events and tasks table size,
and the statistics table size. The Microsoft SQL Server core table corresponds to the database
(/storage/db) partition of the PostgreSQL database. The Microsoft SQL Server events and tasks and
statistics tables correspond to the statistics, events, alarms, and tasks (/storage/seat) partition of the
PostgreSQL database.
During the upgrade of the appliance, you must select a storage size for the new appliance that is at least
twice the size of the Microsoft SQL Server tables size.
Prerequisites
You must have the vCenter Server database login credentials.
vCenter Server Upgrade
VMware, Inc. 152