Is your Operations Manager console slow when editing groups? If so here’s a tip to get you back in the fast lane

Is your System Center Operations Manager 2007 admin console slow when editing groups?  If so, you ought to take a close look at the membership rules, especially if you are using complex regular expression substring searches like below…



Searches like this will result in a very heavy SQL load that can effectively hang the console until the calculation is complete.  It is far better to rewrite the membership rule to combine the search into a single regular expression such as this one below (?i: at the beginning of the expression is a directive to do a case-insensitive search):



To give you some idea of the performance improvement, this very change allowed a query that took approximately 10 minutes to complete to finish in approximately 1 second.

It is worth noting that OpsMgr regularly performs group membership calculation and any improvement in this area is going to result in general performance improvements within OpsMgr.

Hope this helps,

Brian McDermott | System Center Escalation Engineer

clip_image001 clip_image002

Bookmark and Share

Comments (5)

  1. Anonymous says:

    @cornasdf & @all

    To find the groups that possible have a performance impact,  I created a script to retrieve the Discovery Configuration to see if a lot of membership rules and expressions are defined:…/scom-find-those-heavy-group-discoveries.html

    Best regards, Michiel Wouters

  2. Anonymous says:

    Hi 😉 I made a video about this some time ago

    What i did not know was the case sensitive character….

    I found this solution because every month the list of the servers was change.

  3. cornasdf says:

    I would say I definitely have issues in this area.  is there a way to show the calculation queries of each group as a list or report?  Or perhaps a way to show what queries are taking the most time?


  4. @Jonathan – Interesting point about the speed of regexp vs. a bunch of WHERE and OR clauses… you did well pointing it out as it might not be obvious to most. I do find that GroupCalc makes systems very busy, also in terms of Config Churn as those Groups keep changing… something to be aware about.

    @cornasdf – this should be visible on the SQL side, not on the OpsMgr side… likely SQL profiler, or even SQL2005/2008 might have some canned reports in that area….

  5. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    Latest version of Showbox App download for all android smart phones and tablets. – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    Showbox for PC articles:
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings. Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    Sign Up & Do registration for latest movies on Showbox application