Last updated 10-12-10     Large Table query .   (I am putting this at the top, because I use it so much – to find out what is taking up so much space in the OpsDB or DW) SELECT TOP 1000 a2.name AS [tablename], (a1.reserved + ISNULL(a4.reserved...

This is updated as of 4-10-2013    In general - you should evaluate all hotfixes available, and only apply those applicable to your environment.  However, some of these below I have seen impact almost every environment, and should be heavily...

This post is a list of common agent push deployment errors… and some possible remediation options.     Most common errors while pushing an agent:   Error Error Code(s) Remediation Steps The MOM Server could not execute WMI Query "Select...

There is already a very good deployment guide posted on TechNet here:  http://technet.microsoft.com/en-us/library/hh457006.aspx   The TechNet deployment guide provides an excellent walkthrough of installing OpsMgr 2012 for the “all in one” scenario...

The Cumulative Update 5 (CU5) for OpsMgr 2007 R2 has shipped     The KB article describing the fixes, changes, and instructions: http://support.microsoft.com/kb/2495674 Get it from the download Center: http://www.microsoft.com/download/en/details...

Attached to this blog article you will find a PDF file that some of my PFE (Premier Field Engineer) colleagues wrote to help customers in getting started with OspMgr. This is also beneficial when you as an OpsMgr Admin, need a “101”...

  Here is something that a customer brought to my attention, and is probably impacting you already.   They noticed that WMI on some of their Server 2008R2 monitored agents was consuming a large amount of memory – and continually increasing. ...

This is just a dump of some alert description variables I pulled from several other bloggers: Custom Properties for Alert Description and Notification: Alert Description Variables:   For event Rules: EventDisplayNumber (Event ID):            ...

****NOTE OpsMgr 2007 R2 CU5 is now shipped and this is an old article. http://blogs.technet.com/b/kevinholman/archive/2011/08/03/opsmgr-2007-r2-cu5-rollup-hotfix-ships-and-my-experience-installing-it.aspx         The KB article describing...

OpsMgr 2007 Agent troubleshooting: There is a GREAT graphical display of the Agent discovery and push process, taken from: http://blogs.technet.com/momteam/archive/2007/12/10/how-does-computer-discovery-work-in-opsmgr-2007.aspx   Agent Prerequisites...

System Center Operations Manager SDK service failed to register an SPN Have you seen this event in your RMS OpsMgr event logs? Event Type: Warning Event Source: OpsMgr SDK Service Event Category: None Event ID: 26371 Date: 12...

I get asked this every year at MMS - “What should I do if I am completely new to SCOM?”   I wrote this article up a couple years ago in a forum, I have been meaning to publish it here so I can refer to it.   So you are completely new to SCOM...

****NOTE OpsMgr 2007 R2 CU5 is now shipped and this is an old article. http://blogs.technet.com/b/kevinholman/archive/2011/08/03/opsmgr-2007-r2-cu5-rollup-hotfix-ships-and-my-experience-installing-it.aspx       ***Note:  I recommend...

Update 11/29/2012:   This article is current as of the 6.3.173.1 version of the SQL MP.   Using RunAs accounts and profiles is an often poorly understood area of OpsMgr.  As I began to investigate setting this up for the SQL MP, I quickly...

***Note:  This post is edited to reflect the newly shipped MP version 6.0.6958.0   Get it from the download center here:  http://www.microsoft.com/download/en/details.aspx?id=9296     This really looks like a nice addition to...

Do you ever wish you had a list of the rights needed to install OpsMgr on each server role ? Or what each service account needs for steady state? Or how about ongoing support... for your Admin group - to have enough rights in SQL to support OpsMgr? ...

In OpsMgr 2007, it is likely that your most common alert is not really a MP based alert from a technology management pack…. it could be a built-in alert that a script failed, or WMI could not be accessed.  This is because when WMI is broken on a...

Randomly, you might see a single MonitoringHost.exe process on an agent, consuming 100% CPU. (Or 50%, or 25% depending on how many cores you have).  This process will stay at this level, and will not recover.  If you restart the OpsMgr HealthService...

You will likely find that the default retention in the OpsMgr data warehouse will need to be adjusted for your environment.  I often find customers are reluctant to adjust these – because they don't know what they want to keep.  So – they assume...

Sometimes agents either will not “talk” to the management server upon initial installation, and sometimes an agent can get unhealthy long after working fine.  Agent health is an ongoing task of any OpsMgr Admin’s life. This post in NOT an “end to...

The following document will cover a basic install of System Center Virtual Machine Manager 2012 at a generic customer.  This is to be used as a template only, for a customer to implement as their own pilot or POC deployment guide.  It is intended...

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...

When we write rules and monitors to look at events in the event log.... typically the most common criteria are Event ID and Source.  We also have a list of other common event properties to choose from: However, this list doesn't always work. ...

****** 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...

      ****NOTE OpsMgr 2007 R2 CU5 is now shipped and this is an old article. http://blogs.technet.com/b/kevinholman/archive/2011/08/03/opsmgr-2007-r2-cu5-rollup-hotfix-ships-and-my-experience-installing-it.aspx     ----------...