OpsMgr DB Grooming – How it works

fyiSteve 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

Comments (2)

  1. Anonymous says:

    Introducing such a topic you’d like to congratulate you’ve let us know. Have good work…

  2. 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.
    http://movieboxappdownloads.com/ – 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.
    http://www.showboxforipad.org/showbox-apk/ 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

Skip to main content