If System Center Virtual Machine Manager 2008 (SCVMM) has PRO integration with Operations Manager enabled, in certain situations the administrator console may take a long time to load and the memory footprint of vmmadmin.exe may become excessively large.
This can occur if there are too many PRO tips in the SCVMM database. During the initial load of the SCVMM administrator console we also load all PRO tips into the UI, both active and completed, thus potentially causing this issue.
Even though the Jobs view has a built-in grooming cycle, the PRO tips table does not. To purge some of the completed PRO tips from the database use the SQL script below.:
Query deletes all ProTips which
- are closed (@ProTipStateClosed = 7)
- are created @NumberOfDays before today
- don't have a entry in jobs table
DECLARE @NumberOfDays INT, @ProTipStateClosed INT
SET @NumberOfDays = 30;
SET @ProTipStateClosed = 7;
DELETE FROM tbl_PRO_PROTip WHERE
CreationTime <= GETDATE() - @NumberOfDays AND
ObjectState = @ProTipStateClosed
ObjectId NOT IN
-- ProTips that have a job trail.
SELECT Tasks.PROTipID FROM tbl_TR_TaskTrail AS Tasks INNER JOIN tbl_PRO_PROTip AS Protips
ON Tasks.PROTipID = Protips.ObjectId
Once you successfully execute the script, restart the SCVMM administrator console. You should see noticeably increased performance.