6.7

Procedure
1 Log in to a SQL Management Studio session with the vCenter Server database user.
2 Determine the core 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) NOT LIKE 'VPX_HIST_STAT%'
AND UPPER(o.name) NOT LIKE 'VPX_SAMPLE_TIME%'
AND UPPER(o.name) NOT LIKE 'VPX_TOPN%'
AND UPPER(o.name) NOT LIKE 'VPX_TASK%'
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.
vCenter Server Upgrade
VMware, Inc. 153