Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » database   (RSS)
Friday, June 05, 2009 6:59 AM

Maintenance mode – tying the text of the category to the database

I havent seen this discussed before – so I figured I would post this. In the OpsDB and DWDB – we keep some tables names MaintenanceMode and MaintenanceModeHistory. When you place an object into maintenance mode – we will log a row in the database for
Posted by kevinhol | 0 Comments
Filed under: , ,
Tuesday, January 27, 2009 6:54 PM

Populating groups from a SQL server CMDB – step by step

Boris wrote a cool article HERE on how to populate a group of computers in OpsMgr, from an external source…. such as active directory. In his published example – you run an LDAP query to AD, to return a recordset list if computers, in order to populate
Posted by kevinhol | 12 Comments
Attachment(s): SQLBasedGroupDemo.zip
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
Monday, September 29, 2008 7:57 PM

Agent Pending Actions can get out of synch between the Console, and the database

When you look at your agent pending actions in the Administration pane of the console.... you will see pending actions for things like approving a manual agent install, agent installation in progress, approving agent updates, like from a hotfix, etc.
Posted by kevinhol | 4 Comments
Filed under: ,
Saturday, May 03, 2008 12:04 PM

DBcreatewizard or just run good old SetupOM.exe - which should I use to install the Database component of OpsMgr?

There has always been a bit of confusion on when to run the DBCreateWizard.exe tool, or when to just use SetupOM.exe to create the Operational DB or Data Warehouse DB. Historically.... in MOM 2005, we used the DBcreate Wizard in order to create the Onepoint
Posted by kevinhol | 13 Comments
Filed under: ,
Monday, April 21, 2008 11:12 PM

Event ID 2115 A Bind Data Source in Management Group

I see this event a lot in customer environments.  I am not an expert on troubleshooting this here... but saw this post in the MS newsgroups and felt it was worth capturing.... My experience has been that it is MUCH more common to see these when there
Posted by kevinhol | 27 Comments
Filed under: ,
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: ,
Friday, December 14, 2007 4:12 PM

Moving the Data Warehouse and ACS databases in OpsMgr 2007

Moving the Data Warehouse and ACS databases in OpsMgr 2007 Instructions for how to move the data warehouse database, and ACS database – have been published. The Operations Manager 2007 Backup and Recovery Guide has been updated as of December 2007, to
Posted by kevinhol | 0 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: ,
Thursday, October 18, 2007 7:44 PM

Useful MOM 2005 SQL queries

SCDW/DTS:   Primary 6 tables that SCDW data is retained in: SC_AlertFact_Table SC_AlertHistoryFact_Table SC_AlertToEventFact_Table SC_EventFact_Table SC_EventParameterFact_Table SC_SampledNumericDataFact_Table Commands to execute to modify the data
Posted by kevinhol | 2 Comments
Filed under: , ,
 
Page view tracker