SCOM: Updated SQL Server Management Packs v6.7.2.0

Share on Social Media

After many iterations of community previews there is now a non-preview release of the SQL management packs they can be downloaded from the below locations:

Due to the many issues with some of the recent versions of the SQL management packs I would strongly advise extensive testing before deployment to production systems.

SQL Server 2016 v6.7.2.0 – here
SQL Server 2014 v6.7.2.0- here
SQL Server 2005 / 2008 / 2012 v6.7.2.0- here
SQL Server 2016 Analysis Services v6.7.2.0- here
SQL Server Dashboards v6.6.7.6 – here
SQL Server 2016 Replication v6.7.2.0- here
SQL Server 2014 Replication 6.6.4.0 – here
SQL Server 2012 Replication v 6.7.2.0 – here
SQL Server 2008 Replication v6.7.2.0 – here
SQL Server 2016 Reporting Services (Native Mode) v 6.7.2.0- here

Changes and Fixes

SQL Server Replication

  • Decreased database timeout value for some workflows to match new connection logic
  • Updated the visualization library

SQL Dashboards

  • Changed some stored procedures to improve Dashboards performance

SQL Server 2005 / 2008 / 2012 / 2014

  • Added rules for alerting when an Availability Replica changed its role and/or a Database Replica changed its role
  • Created a group for WOW64 SQL Server instances and disabled launching of some workflows for these instances
  • Added MP version line into MP’s events generated by the scripts
  • Fixed the display strings and Knowledge Base articles
  • Fixed issue: some scripts were not returning data when one of the few installed instances was stopped
  • Fixed issue: SPN configuration monitor used stale data
  • Fixed: mirroring monitoring scripts were failing when the instance was stopped

SQL Server 2016

  • Changed EventID for MP events generated by the scripts (became 4202 for the Always On scripts and 4211 for the others)
  • Disabled Memory-Optimized Data workflows for SQL Server 2016 Express
  • Added new performance rules for Always On Log Apply Pending/Ready Queue counters
  • Added rules for alerting when an Availability Replica changed its role and/or a Database Replica changed its role
  • Added MP version line into MP events generated by the scripts
  • Fixed the display strings and Knowledge Base articles
  • Fixed issue: some scripts was not returning data when one of the few installed instances was stopped
  • Fixed issue: SPN configuration monitor used stale data
  • Run As profiles are now presented in GPMP library and ready to become generic profiles for all SQL Server MPs starting with 2016
  • Fixed issue: mirroring monitoring scripts were failing when the instance was stopped

SQL Server Analysis Services and Reporting Services (Native Mode) 

  • Updated the visualization library
  • Run As profiles are now presented in GPMP library and ready to become generic profiles for all SQL Server MPs starting with 2016

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.