Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » grooming » database   (RSS)
Tuesday, November 04, 2008 11:24 PM

Boosting OpsMgr performance - by reducing the OpsDB data retention

Here is a little tip I often advise my customers on..... The default data retention in OpsMgr is 7 days for most data types:     These are default settings which work well for a large cross section of different agent counts.  In MOM 2005
Posted by kevinhol | 0 Comments
Saturday, April 12, 2008 12:38 AM

What SQL maintenance should I perform on my OpsMgr databases?

This question comes up a lot.  The answer is really - not what maintenance you should be performing... but what maintenance you should be *excluding*.... or when.  Here is why: Most SQL DBA's will set up some pretty basic default maintenance
Posted by kevinhol | 8 Comments
Filed under: ,
Wednesday, February 13, 2008 2:51 AM

Grooming process in the Operations Database

This is a continuation of my other post, on general alert grooming: How grooming and auto-resolution work in the OpsMgr 2007 Operational database   Grooming of the OpsDB is called once per day at 12:00am…. by the rule:  “ Partitioning
Posted by kevinhol | 2 Comments
Filed under: ,
Tuesday, February 12, 2008 12:19 AM

Print Server management pack fills the Operational DB with TONS of perf data

This is something I have noticed in MOM 2005, and seems to be the same in the conversion MP for OpsMgr 2007.  (Version 6.0.5000.0 of the Microsoft.Windows.Server.Printserver (Converted) MP).  When you import this MP, it will fill the Operational
Posted by kevinhol | 1 Comments
Tuesday, February 05, 2008 5:02 PM

Failed tasks aren't groomed from the Operational Database

This appears to be present up to RC-SP1 version, build 6.0.6246.0   In the Task Status console view - I noticed an old failed task from 2 months ago..... however, my task grooming is set to 7 days.   To view the grooming process: http://blogs.technet.com/kevinholman/archive/2007/12/13/how-grooming-and-auto-resolution-work-in-the-opsmgr-2007-operational-database.aspx
Posted by kevinhol | 1 Comments
Filed under: ,
Thursday, December 13, 2007 11:22 PM

How grooming and auto-resolution work in the OpsMgr 2007 Operational database

How Grooming and Auto-Resolution works in the OpsMgr 2007 Operations DB Warning – don’t read this if you are bored easily. In a simplified view to groom alerts….. Grooming of the ops DB is called once per day at 12:00am…. by the rule: “ Partitioning and
Posted by kevinhol | 2 Comments
Filed under: ,
 
Page view tracker