Friday, October 16, 2015

SCOM - New SQL 2012 & 2014 Management Packs with Bug Fixes Released

Yesterday I noticed that a new release (version of the SQL 2012 & 2014 management packs has just landed and there's a lot of people out there who've been waiting on them.

Important Update - 21st October 2015: There have been a few reports about a bug in this latest management pack - which seems to have also been present in the previous MP release - where the SQL database logs on your DW server can fill up in certain scenarios. For this reason, it's a good idea to hold off deploying these MP's into production until Microsoft release a fix for this (as far as I know, Microsoft are aware of the issue and are working on a solution).

The previous release (version brought a new dashboard template and visualizations....

Unfortunately, many people (myself included) that deployed this MP ran into problems when viewing the SQL Server Summary Dashboard. As you can see from the comments section at the end of this TechNet post - this was a widespread issue...

Thankfully, Microsoft have identified this as an issue and have listed this as a fix in the latest release of the MP:

I've deployed this updated MP into my lab and so far, it seems to have fixed the issue for me - although it took a few days to manifest itself in the last MP so let's see how this one goes!

There's also a few new visualization options that you can choose from as you can see from Microsoft's post on the new MP's here.

You can download the new SQL management packs using the SCOM MP Wiki or directly from here (SQL 2012) and here (SQL 2014).

Note: As of the time of writing this post, these updated MP's are not available through the built-in catalog option in SCOM but I'd expect them to light up there in the coming days too.


  1. I added the SQL 2014 MP last week and updated to this morning and filled the logs on the SCOM DW and still have errors in on the Management Servers

    Any suggestions. Should i remove the MP and re import it?

    Issue also logged here:

    Alert Details

    Data Warehouse failed to deploy database component. Failed to deploy Data Warehouse component. The operation will be retried.

    Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: Script, Id: '4173391e-ce71-1369-c358-17030bb09b41', Management Pack Version-dependent Id: '8152d5f4-c958-2b42-2a56-a8fff2ea3f98'; Target: Database, Server name: 'colo-scomdw', Database name: 'OperationsManagerDW'. Batch ordinal: 39; Exception: Sql execution failed. Error 9002, Level 17, State 4, Procedure Microsoft_SQLServer_Visualization_Library_UpdateHierarchy, Line 192, Message: The transaction log for database 'OperationsManagerDW' is full due to 'ACTIVE_TRANSACTION'.

  2. Hi Kevin, when i try to create a new Dashboard View based on this new SQL Server Dashboards, the associated template just doesn't show up. I've already confirmed that i'm running v6.6.4.0 on all SQL MP's. Can you help me? Thanks