Management Group Performance Evaluation and Tuning Reports

I created a small management pack a couple years ago to help identify performance bottlenecks in an Operations Manager 2007 R2 environment.  It started with a couple collection rules targeting the core SCOM server roles.  I would then query the database and paste results into an Excel spreadsheet.  Evaluating all the data and formatting the…

6

Can the SCOM databases share a SQL instance with other databases?

Just wanted to answer this question here as a pointer for later reference.  But before I continue, I want to mention that this is from the perspective of SCOM.  You’ll need to read documentation of your specific application before collocating your other database with the SCOM db’s.   The biggest concern will be one of performance. …

2

When was the last time this agent inserted data and what was the latency?

This is one way to check whether a particular agent is communicating with the management group.  Just replace FQDN with the agent you want to test, and this will return the last sampled DateTime stamp.  We will also see when the data was actually inserted into the database, which allows us to calculate a ‘Latency’…

0

Console sluggish or frozen during agent approval process

I was working with a large customer last week, and found some very interesting performance metrics which impact console sessions.  This particular customer pushes the limits of Operations Manager 2007 in every way.  They have 6000+ agents in a single Management Group, and have an average of 50 concurrent console sessions at any given point…

0

How to measure Operations Manager database performance

In order to make any kind of performance tuning recommendations, it is first necessary to capture a baseline of normal operating conditions.  What I’d like to demonstrate in this post is how to measure the performance of your Operations Manager database disks.  The disks hosting the Operations Manager database must be able to comfortably sustain…

9