Vcenter DB/Log Shrink
– use the script here: http://www.dbforums.com/microsoft-sql-server/1003535-query-showing-tablesize-mb.html to prints out an really nice report on each table space usage;
– to delete statistics history: run the purge script, found here: http://kb.vmware.com/kb/1025914;
– to delete events and tasks history: set correct database retention policy in vCenter: Administration -> vCenter Server settings (or manually delete records from tables VPX_TASK, VPX_EVENT and VPX_EVENT_ARG;
– finally shrink database (either by executing DBCC SHRINKDATABASE (VCDB); or Database Properties / Tasks / Shrink / Database)
– optionally you may want to defrag indexes, as described here: indexdefrag (http://kb.vmware.com/kb/1003990)
