Hey guys,
I've noted a common complaint, that vCenter is often quite slow to respond. I've found a significant improvement to our environment with the below process that I developed, which optimises the SQL database.
USE VIM_VCDB;
EXEC sp_MSforeachtable @command1="print 'Rebuilding indexes for ?' ALTER INDEX ALL ON ? REBUILD WITH (FILLFACTOR = 90)" ;
EXEC sp_updatestats;
GO;
This simple process can be automated on a full featured SQL server using the maintenance wizard - however - indexes and statistics become poor on standalone databases.