OpsMgr – SQL MP version 6.4.1.0 capabilities and configuration

Download:  http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=10631 On 10/14/2013 The SQL MP was updated.  There is a huge number of updates, fixes, and new features that were released in this version (and the version which shipped in Sept 2013.)  See the download link for all the updates, or the MP guide that ships with this version. SQL Server Management Pack…

35

How to monitor SQL Agent jobs using the SQL Management Pack and OpsMgr

When you use Operations Manager to monitor your SQL servers using the SQL Server Management Pack, there are some options that you will need to think about up front.   One of those areas is the SQL Agent, and SQL Agent jobs.   I will cover three conceptual areas: Out of the box experience and defaults…

9

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

Configuring Run As Accounts and Profiles in OpsMgr – A SQL Management Pack Example

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 realized how little I understood it.  Chatting with my PFE peers, I…

63

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

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

Stop monitoring SQL Express and Windows Internal Database

The Microsoft SQL Server management packs for 2005 and 2008 will discover and monitor SQL 2005 Express edition and the Windows Internal Database by default.  This is often not desired, and causes a lot of noise in the management group, because these are not full blown instances of SQL, and some of our default monitoring…

25

What is config churn?

There have been a couple good articles briefly covering this topic…. you might have read them.  I will reference some below.  Config churn is basically, when your RMS is in an almost never-ending loop of generating config.  This can be caused by “less than optimized” management packs, pushing agents all the time, or injecting major…

14