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

Article ID: 2027023 - View products that this article applies to.
Expand all | Collapse all

Symptoms

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.  

Cause

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.

Resolution

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

Properties

Article ID: 2027023 - Last Review: May 6, 2010 - Revision: 1.0
APPLIES TO
  • Microsoft System Center Virtual Machine Manager 2008
  • Microsoft System Center Virtual Machine Manager 2008 R2 Workgroup Edition
Keywords: 
KB2027023

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com