Select the product you need help with

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.

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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.

Back to the top | Give Feedback

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

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

Back to the top | Give Feedback