But these Groups – when created too enthusiastically without much planning – can create issues in any SCOM environment. When one uses too complex regular expressions it will result in a very heavy SQL load that can hang the SCOM Console…
So the OpsMgr Support Team Blog posted an article how to go about it, to be found here.
Nice thing is that Michiel Wouters wrote a posting on this topic as well and posted it on his own blog. This posting is an excellent follow up since his posting contains a PS script which helps to find the heavy Group discoveries.