If you are using SQL 2008 R2 for OpsMgr DB’s, you need SQL 2008R2 CU5

  There is an issue where your SQL server hosting the OperationsManager database might consume large amounts of CPU for extended periods.  This is due to a security cache issue when a non-sysadmin creates a heavy workload on a TempDB database.  Read more about this on the support team blog: http://blogs.technet.com/b/operationsmgr/archive/2011/02/03/fix-sql-server-hits-100-cpu-utilization-when-there-are-configuration-update-requests-in-scom-2007.aspx     This SQL…

2

How to collect performance data for SQL databases (multi-instance objects)

I have had several blog posts in the past discussing how to write rules and monitors against multi-instance objects.  Special care must always be taken when writing workflows against classes where an agent can host more than one instance of the same class type.  Examples would be Logical Disk, SQL DB Engine, SQL Database, etc….

8

After moving your OperationsManager Database–you might find event 18054 errors in the SQL server application log

I recently wrote about My Experience Moving the Operations Database to New Hardware.  Something I noticed today – is that the application event log on the SQL server was full of 18054 events, such as below: Log Name:      Application Source:        MSSQL$I01 Date:          10/23/2010 5:40:14 PM Event ID:      18054 Task Category: Server Level:         Error Keywords:      Classic…

23

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

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…

13

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…

20

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…

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

Understanding and modifying Data Warehouse retention and grooming

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 the defaults are good – and they just keep EVERYTHING.  This…

78

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 this object.  You could potentially write reports against this…

2

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 them into a group.  This post will extend…

33

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 – we defaulted to 4 days.  Many customers, especially with…

0

Does your OpsDB keep growing? Is your localizedtext table using all the space?

This post is about an issue in OpsMgr SP1 AND R2 – where the localizedtext table in the database may fill and consume large amounts of space. OpsMgr 2007 no longer has a hard database limit of 30GB like MOM 2005 did.  For this reason, most OpsMgr administrators don’t watch this very closely anymore, or…

61

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.   This pending action information is also contained in the SQL table in the OpsDB…

15

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 database on Active/Active clusters….. or when SQL DBA teams refused…

13

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 is a management pack that collects way too…

39

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…

31

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