6.5.1

AND UPPER(o.name) NOT LIKE 'VPX_EVENT%'
AND UPPER(o.name) NOT LIKE 'VPX_SDRS_STATS_VM%'
AND UPPER(o.name) NOT LIKE 'VPX_SDRS_STATS_DATASTORE%'
AND UPPER(o.name) NOT LIKE 'VPX_PROPERTY_BULLETIN%';
The script returns the database storage size in MB.
3 Determine the events and tasks table size by running the following script.
SELECT SUM(p.used_page_count * 8)/1024 AS disk_size
FROM sys.dm_db_partition_stats p
JOIN sys.objects o
ON o.object_id = p.object_id
WHERE o.type_desc = 'USER_TABLE'
AND o.is_ms_shipped = 0 AND ( UPPER(o.name) LIKE 'VPX_TASK%'
OR UPPER(o.name) LIKE 'VPX_EVENT%');
The script returns the events and tasks storage size in MB.
4 Determine the statistics table size by running the following script.
SELECT SUM(p.used_page_count * 8)/1024 AS disk_size
FROM sys.dm_db_partition_stats p
JOIN sys.objects o
ON o.object_id = p.object_id
WHERE o.type_desc = 'USER_TABLE'
AND o.is_ms_shipped = 0
AND ( UPPER(o.name) LIKE 'VPX_HIST_STAT%'
OR UPPER(o.name) LIKE 'VPX_SAMPLE_TIME%'
OR UPPER(o.name) LIKE 'VPX_TOPN%');
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 Microsoft SQL Server 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 Microsoft SQL Server
events and tasks and statistics tables returned in Step 3 and Step 4.
For example, if the Microsoft SQL Server 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.
vSphere Upgrade
VMware, Inc. 180