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
