locked
SQL MP 6.6.4.0 and SQL MP for 2014 6.6.4.0 - Discovery issues RRS feed

  • Question

  • Hi chaps,
    I normally lurk in the RDS and Hyper-V forums but I dabble with SCOM also so bear with me...

    We are running SCOM 2012 R2 UR6 with ~ 700 Managed Agents
    We recently upgraded our SQL MPs to version 6.6.4.0, we run 2008,2012 and 2014 DBs so imported both the SQL Management Packs and the 2014 specific packs (of the same version). But we are seeing some odd issues with discoveries.

    In the MOM log on a few 2012 instances we are seeing these:


    Rule/Monitor "Microsoft.SQLServer.2012.UserConnectionsCollection" running for instance "SQL02" with id:"{442A0759-53E8-30C4-6B66-861B6D81E48F}" cannot be initialized and will not be loaded. Management group "MyManagementGroup"

    Rule/Monitor "Microsoft.SQLServer.2012.NumberDeadlocksPerSecond" running for instance "SQL02" with id:"{442A0759-53E8-30C4-6B66-861B6D81E48F}" cannot be initialized and will not be loaded. Management group "MyManagementGroup"

    Rule/Monitor "Microsoft.SQLServer.2012.LockWaitsPerSecond" running for instance "SQL02" with id:"{442A0759-53E8-30C4-6B66-861B6D81E48F}" cannot be initialized and will not be loaded. Management group "MyManagementGroup"

    Rule/Monitor "Microsoft.SQLServer.2012.SQLRecompilesPerSecond" running for instance "SQL02" with id:"{442A0759-53E8-30C4-6B66-861B6D81E48F}" cannot be initialized and will not be loaded. Management group  "MyManagementGroup"

    Rule/Monitor "Microsoft.SQLServer.2012.SQLCompilationsPerSecond" running for instance "SQL02" with id:"{442A0759-53E8-30C4-6B66-861B6D81E48F}" cannot be initialized and will not be loaded. Management group "MyManagementGroup"

    Rule/Monitor "Microsoft.SQLServer.2012.BufferCacheHitRatio" running for instance "SQL02" with id:"{442A0759-53E8-30C4-6B66-861B6D81E48F}" cannot be initialized and will not be loaded. Management group  "MyManagementGroup"

    As a workaround (as some of these are very important to our DBAs) I thought Id recreate the "User connections" rule.
    So in my own MP I created a new rule targeting the below object:
    $Target/Property[Type="MicrosoftSQLServerLibrary6066480!Microsoft.SQLServer.DBEngine"]/PerformanceCounterObject$:General Statistics

    And the below Counter:
    User Connections

    I targeted the rule as "SQL DB Engine" and enabled it.
    Great, collecting data for 2008 and 2012 no issues. However 2014 is not.

    Does this mean i'm going to have to recreate the rule(s) and target them at a group (SQL Server DB engine Group) rather than the DB Engine Class? Also has anyone else seen the above failures for these MPs? Id much rather not have to recreate them but I suspect I have no choice.


    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember, if you see a post that helped you please click "Vote as Helpful", and if it answered your question, please click "Mark as Answer". I do not work for Microsoft, I manage a large estate in the public sector, my views are generally first hand production experiences.

    Wednesday, November 25, 2015 12:33 PM

Answers