The 31552 event, or “why is my data warehouse server consuming so much CPU?”

A very common customer scenario – is where all of a sudden you start getting these 31552 events on the RMS, every 10 minutes.  This drives a monitor state and generates an alert when the monitor goes red.   However – most of the time my experience is that this alert gets “missed” in all…

32

ADMP for Windows Server 2008 – Alerts not generated for some Rules

There is a very recently discovered issue in the current ADMP (Version 6.0.7065.0).  The Event log rules in the Microsoft.Windows.Server.AD.2008.Monitoring.mp don’t generate alerts as expected.  Jimmy Harper has created an “Addendum” MP which contains overrides to disable all of these, and then recreated each rule with a fixed version.  You’ll just need to import this…

0

Moving the Operations Database–My Experience

The time has come to move my Operations Database Server role to a new server in my lab.  Today – this is installed on a single server (named OMDB).  This server is running Windows Server 2008 SP2 x86, and SQL 2008 SP1 DB engine (32bit to match the OS).  This machine is OLD, and only…

16

Moving the Data Warehouse Database and Reporting server to new hardware–my experience

The time has come to move my Warehouse Database and OpsMgr Reporting Server role to a new server in my lab.  Today – both roles are installed on a single server (named OMDW).  This server is running Windows Server 2008 SP2 x86, and SQL 2008 SP1 DB engine and SQL Reporting (32bit to match the…

24

SQL MP version 6.1.314.36 released–adds support for SQL 2008R2 and many other changes

The SQL Management Pack has been updated.  This is the biggest update to the SQL MP, probably since we added support for SQL 2008. Version 6.1.314.36 brings many changes to the MP – so you should give careful consideration to this one.  It is not simply a handful of bug fixes, for sure.   Download…

7

OpsMgr 2007 R2 Connectors – Cumulative Update 2 shipped

This is an update, if you use the Microsoft branded OpsMgr R2 connectors.   KB Article:  http://support.microsoft.com/?kbid=2274165 Download location:  http://www.microsoft.com/downloads/details.aspx?FamilyID=87c27d91-4549-4169-a87a-ca88e4136e4f&displaylang=en   This is a cumulative update – which also includes the fixes in the previously shipped update, 975774.   Changes in this update:   Support for HP Operations Manager for UNIX v9 This update enables…

2

How to create a monitor to inspect the value of a registry key

In my previous post similar to this topic, we discussed how to check for the existence of a registry key or value, and alert/change state if it was missing.  But what if you want to inspect the contents of a registry value for specific data? For instance – what if we want to inspect a…

19

OpsMgr 2007 SP1 CU1 hotfix ships – and my experience installing it

      The SP1 Cumulative Update 1 (CU1) for OpsMgr 2007 SP1 has shipped     Get it from the download Center: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=62b6c324-38b9-47df-bd89-a62908f0b642   The KB article describing the fixes, changes, and instructions: http://support.microsoft.com/?kbid=2028594               If you are running OpsMgr 2007 R2 – disregard.   This is for…

6

Logical Disk Availability is critical – what does this mean?

  You might have noticed a logical disk availability monitor, being red on some of your systems. In more recent MP’s – this monitor was renamed to “File System error or corruption” One of the challenges with this monitor – is that it has really good product knowledge, but the state change context doesn’t give…

14

How to create a monitor for existence of a registry key

There are many examples of using a discovery for a new class or extended class, based on a registry key. What if – you just want to monitor for a specific registry key – and turn your agents to a warning or critical state if it is missing?    Consider the scenario: CompanyX stamps the…

19

Authoring groups – from simple to complex

I have written many individual blog posts on creating and using groups.  I wanted to take this post to put them all in one place – the most common examples of “how-to” create groups for all kinds of common scenarios.  Some of these are super simple.  Some are overly complex, and provide us a challenge…

3

How to monitor a process on a multi-CPU agent using ScaleBy

The business need: It is a very common request to monitor a process on a given set of servers, and collect that data for reporting, or monitor it for a given threshold. One thing you might notice when trying to monitor some performance counters, is that not all perf counters in perfmon behave the way…

12

Why do I have duplicate SQL databases or logical disks in the console after a version upgrade?

This is a rare but interesting scenario… which can cause you to see and monitor duplicate objects (and get duplicate alerts) for specific types of discovered hosted objects that have a parent class which was upgraded from one version to another. For instance – if you upgrade SQL 2005 > SQL 2008, or Windows 2000…

1

How to monitor events logged by another computer or cluster

Or – How to use the <AllowProxying> XML item.   When you monitor the event log in OpsMgr, there is some built in security that the agent modules perform.  Normally this wont affect you, except for unique situations where events are logged from/by another computer, or in the case of MS Clusters, where events get…

2

System Center Central – some really cool OpsMgr Health reports available

System Center Central has published some really good reports – which will help you keep up with the health of your environment. http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/73350/Default.aspx   Many of these are based on queries published on my blog and other blogs in the community, but they have wrapped a lot of the most common queries into a set…

1

OpsMgr 2007 R2 Core MP’s updated 6.1.7672.0

  Update 11/24/2010 – this MP has been superseded by a newer update:  http://blogs.technet.com/b/kevinholman/archive/2010/11/24/opsmgr-2007-r2-core-mp-s-updated-6-1-7695-0.aspx  This article is out of date.       The core MP’s have been updated on their regular schedule.  If you are running OpsMgr 2007 R2 – you should update these as soon as possible. http://www.microsoft.com/downloads/details.aspx?FamilyID=61365290-3c38-4004-b717-e90bb0f6c148&displaylang=en   Microsoft.SystemCenter.2007.mp 6.1.7672.0 Microsoft.SystemCenter.OperationsManager.2007.mp 6.1.7672.0…

10

All OpsMgr Events in a spreadsheet by ID

Daniele Muscetta (Microsoft PFE) has published a VERY handy spreadsheet, which contains all the OpsMgr events and their descriptions.  This is a super handy reference when looking up events, especially when someone is verbally calling them out, or you dont have the OpsMgr DLL’s to read the log. http://blogs.msdn.com/b/dmuscett/archive/2010/06/23/opsmgr_2d00_event_2d00_ids_2d00_spreadsheet.aspx  

0

Management group checkup – a database perspective

Attached you will find a PowerPoint slide deck that I used to present to the System Center Virtual Users Group meeting on June 11th. This discussion was looking at your management group overall health from a database perspective.  There are many facets to the health of SCOM, this is just one perspective.  I discussed SQL…

1

WMI leaks memory on Server 2008 R2 monitored agents

  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.  I started tracking this in SCOM by writing a rule to collect the Process\Private…

44

Installing Exchange 2010 into a test lab

As a SCOM admin, I don’t need to be an Exchange 2010 “expert”.  However, I do need to be familiar enough with the MP, and how it interacts with a live Exchange environment, to be prepared for when my company rolls out Exchange 2010.  SCOM admins have to touch just about every technology out there,…

4