You are currently offline, waiting for your internet to reconnect

The System Center Virtual Machine Manager 2008 administrator console may take a long time to load

This article has been archived. It is offered "as is" and will no longer be updated.

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;
    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.

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Article ID: 2027023 - Last Review: 12/12/2015 08:11:05 - Revision: 1.0

Microsoft System Center Virtual Machine Manager 2008, Microsoft System Center Virtual Machine Manager 2008 R2 Workgroup Edition

  • kbnosurvey kbarchive KB2027023