Steve Rachui just posted a great article on how grooming works in System Center Operations Manager 2007, so if you missed this and was ever curious how all this came together then you’ll definitely want to check this out. I have his intro and a link below:
A while back I wrote up a blog post on how grooming works for the OpsMgr DB and the warehouse http://blogs.msdn.com/steverac/archive/2007/12/13/scom-2007-operational-and-datawarehouse-grooming.aspx
Recently I put the detailed grooming steps for the OpsMgr DB into a graphical form that I share here. Please note – even though there are specific tables shown here don’t consider this posting sanction to modify these tables. Doing so is unsupported and the tables are included here as information only and to show the total snapshot of the grooming process. Further, the diagram below shows the detail around grooming the OpsMgr DB for partition objects (event/perf) but leaves detail about grooming other data types, such as self-tuning threshold data, alerts, state changes, job status, etc. Information about ACS grooming, discovery data grooming, data warehoulse grooming, etc., is also absent. All that to say, grooming is a multi-step process and, while many of the moving parts are shown below, many are also not detailed.
For more information see OpsMgr DB Grooming – How it works.
J.C. Hornbeck | Manageability Knowledge Engineer