If you have enabled the PRO integration with operations manager in your VMM environment, then this blog post might be for you. If your VMM Administrator Console is taking too long to load and the memory footprint of the vmmadmin.exe is too large (i.e. the vmmadmin.exe is taking up too much RAM), then it is possible that you have a lot of PRO tips in the VMM Database and they need to be purged. During the initial load of the Administrator Console, we also load all PRO tips in the UI, both active and completed ones, causing this side effect.
Even though our Jobs view has a built-in grooming cycle, the PRO tips table does not. if you would like to purge some of the completed PRO tips, you can do that using the SQL script in this blog post.
Query deletes all ProTips which
- are closed (@ProTipStateClosed = 7)
- are created @NumberOfDays before today
- don't have a entry in jobs table