What SQL maintenance should I perform on my OpsMgr databases?

  This article is for SCOM 2007.  It does not apply to SCOM 2012.  See updated article for SCOM 2012.   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…

33

Active Directory Integration – How it works

Steve Rachui wrote a great post on this – which goes a little deeper than some of the other documents and blogs presently out there: http://blogs.msdn.com/steverac/archive/2008/03/20/opsmgr-ad-integration-how-it-works.aspx I want to add one comment: Q:  “How often does the agent poll active directory if it doesn’t find policy when the machine first joins the domain?” A:  The…

0

Using a recovery in OpsMgr – Basic

This is a simple overview of using a recovery for a custom Monitor in OpsMgr Lets say we create a simple service monitor in OpsMgr… for this example – I will use the Print Spooler service: Create a new monitor, unit monitor, and choose windows services – Basic Service Monitor: Choose an appropriate management pack…

27

System Center Operations Manager 2007 UNLEASHED

Got my copy of this book today: http://ops-mgr.spaces.live.com/ http://www.amazon.com/System-Center-Operations-Manager-Unleashed/dp/0672329557   Over 1200 pages!  1300 with appendices!  WOW!  Guess I know what I will be doing for the next couple weeks. Given their MOM 2005 Unleashed book was the best MOM 2005 book I read…. I have high hopes for this one.

0

Self Tuning Thresholds – love and hate

******  The references in this post to the Exchange Management Pack have been changed… many of these issues below have been addressed in the updated MP:  http://blogs.technet.com/kevinholman/archive/2008/08/22/updated-exchange-2003-mp-released-version-6-0-6387-0.aspx     Self tuning thresholds are a new concept for OpsMgr.  They are awesome – because they will “learn” what is normal for a performance counter, and alert when…

25

ACS Internals – Part 1

  I am going to use this post ramble about a couple of the internals of ACS. Database: The ACS DB is primarily made up of daily partition tables…. we create a new one every day during the nightly maintenance, which defaults to 1AM.  We create a new partition, then close the previous one.  Then,…

18

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 and Grooming” You can search for this rule in the Authoring space of the console, under…

5

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 and reporting databases with performance data about print jobs and queues, if you have a large…

1

Installing the OpsMgr 2007 agent on an ISA 2004 or ISA 2006 server

When you want to manage and monitor an ISA server, you need to install the OpsMgr agent. However, there is no guide published for the OpsMgr 2007 ISA MP…..   It comes with the MOM 2005 guide.  In ISA, there was a system policy which you could enable for MOM.  This would open the necessary ports…

3

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 Basically – select * from PartitionAndGroomingSettings will show you all…

2

Creating a Group based on OU (Organizational Unit) in Active Directory

  Here is a really cool feature of Opsmgr:  the ability to create groups easily based on any discovered attribute of an object.   OU is something that is part of the Windows Computer object discovery.  If you examine a state view – you will see in the details pane discovered information… and OU is…

10

Repeating event monitor alert description variables don’t work

  This is current as of RC-SP1 version of OpsMgr 2007. When you create a repeating event monitor, and use the GUI to add in some Alert description variables, such as event ID, Description, etc… you will find that they do not work.  Below are the correct variables to use for repeating event monitors:  …

5

Configuring Notifications – to include specific alerts from specific groups and classes

So…. Say I am an Exchange Administrator in a global company…. in the good old USA. My company has recently implemented OpsMgr 2007 to monitor our Exchange servers.  I am going to configure my notification subscriptions so I can get an email anytime one of my Exchange servers has an issue. Try #1:  I start…

19

How do I delete an attribute in OpsMgr 2007?

I notice – when viewing a custom attribute, there is no option to delete it… only view the properties? Apparently this is by design.  There is no harm in having “extra” attributes in SCOM – that arent used.  However, if you do want to delete an unused attribute – you will have to export your…

0

MOM 2005 SP1 – upgrading SQL server from 2000 to 2005

  Upgrading from SQL 2000 to SQL 2005 to support MOM 2005 SP1: 1. Backup your MOM SQL server databases (OnePoint and Systemcenterreporting). Backup your Microsoft SQL Server Reporting Services databases. 2. Backup the SRS encryption key. 3. Stop the MOM Service on all management servers. 4. Upgrade the database servers and reporting servers to…

0

Tired of your console throwing errors – or manually clearing your console cache?

You can tell the Ops console to clear the cache everytime you open it!  Just change your shortcut – and add the /clearcache parameter:  “C:\Program Files\System Center Operations Manager 2007\Microsoft.MOM.UI.Console.exe” /clearcache   Keep in mind – this is no longer recommended post SP1 RTM….. just when you are having a problem.  By using this setting on all…

4

Got links?

Links you say?     Main Opsmgr Microsoft site: http://www.microsoft.com/systemcenter/opsmgr/default.mspx   OpsMgr Documentation: http://technet.microsoft.com/en-us/opsmgr/bb498235.aspx   OpsMgr Online Help: http://technet.microsoft.com/en-us/library/bb310604.aspx   Management Pack Catalog: http://www.microsoft.com/technet/prodtechnol/scp/catalog.aspx   OpsMgr TechCenter: http://technet.microsoft.com/en-us/opsmgr/default.aspx   Virtual Hands On Labs: http://technet.microsoft.com/en-us/bb539977.aspx   OpsMgr training videos and demos: http://technet.microsoft.com/en-us/opsmgr/bb498237.aspx   On Demand Webcasts: http://www.microsoft.com/events/series/technetmms.aspx?tab=webcasts&id=42365   OpsMgr Resource Kit: http://technet.microsoft.com/en-us/opsmgr/bb625978.aspx   OpsMgr SDK: http://msdn2.microsoft.com/en-us/library/bb437575.aspx…

0

How do I collect data from a multi-instance object – like a SQL DB instance?

How do I collect data from a multi-instance object – like a SQL DB instance?   This was a common question in the RTM version of the product.    If I wrote a rule to collect performance data against a SQL DB engine – I needed to specify the “instance” name.   The most common approach,…

0

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 include moving the DW and ACS DB’s, in addition to the…

3

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

How Grooming and Auto-Resolution works in the OpsMgr 2007 Operations DB 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 Grooming”  You can search for this rule in the Authoring space of the console, under Rules.  It is targeted…

22