SQL 2012 AlwaysOn discoveries broken in RRS feed

  • Question

  • It looks like version of the SQL 2012 MP broke discovery of AlwaysOn (the AlwaysOn Seed). The old version had this for the registry key (note the bit in red, it's missing from the new one):

    SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.$Target/Property[Type="SQLServer!Microsoft.SQLServer.ServerRole"]/InstanceName$\MSSQLServer\HADR\HADR_Enabled

    And then this is

    SOFTWARE\Microsoft\Microsoft SQL Server\$Target/Property[Type="SQLServer!Microsoft.SQLServer.DBEngine"]/InstanceID$\MSSQLServer\HADR\HADR_Enabled

    The discovery works fine for our management group that's using the old version, but it's not working for our MG using the new version. Is anyone else running into this?

    "Fear disturbs your concentration"

    Wednesday, January 8, 2014 10:36 PM


  • Hi,

    SQL Server Management Pack version improves performance of AlwaysOn discovery.

    Appendix: AlwaysOn Management Pack Contents

    Please ensure your Management Server with latest update installed. Also check if there is any related event.

    Niki Han

    TechNet Community Support

    • Marked as answer by Niki Han Wednesday, January 22, 2014 9:46 AM
    Friday, January 10, 2014 5:36 AM