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