Released: System Center Management Pack for SQL Server, Replication, AS, RS, Dashboards (6.7.15.0)

We are happy to announce new updates to SQL Server Management Pack family. All Management Packs are available in all 11 languages!

Microsoft System Center Management Pack for SQL Server enables the discovery and monitoring of SQL Server Database Engines, Databases, SQL Server Agents, and other related components.

Microsoft System Center Management Pack for SQL Server Replication enables the monitoring of Replication as set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

Management Pack for SQL Server Analysis Services enables the monitoring of Instances, Databases and Partitions.

Management Pack for SQL Server Reporting Services (Native Mode) enables the monitoring of Instances and Deployments.

Please see below for the new features and improvements. More detailed information can be found in guides that can be downloaded from the links above.

New SQL Server 2008/2008 R2/2012 MP Features and Fixes

No extra permissions on remote WMI are now required for Local System account when Always On hosts have names that are no longer than 15 symbols
Fixed: Always On discovery and monitoring scripts cannot read cached values in Windows registry
Fixed: Wrong MP version number in some Always On scripts
Fixed: CPUUsage and DBDiskLatency scripts fail with the reason: “Index operation failed”
Added retry policy in some Always On workflows to make PS-scripts work more stable
Updated the visualization library
Changed behavior of Always On scripts for cases when WSFC service is stopped

New SQL Server 2014/2016 MP Features and Fixes

No extra permissions on remote WMI are now required for Local System account when Always On hosts have names that are no longer than 15 symbols
Fixed: Always On discovery and monitoring scripts cannot read cached values in Windows registry
Fixed: Wrong MP version number in some Always On scripts
Fixed: CPUUsage and DBDiskLatency scripts fail with the reason: “Index operation failed”
Added retry policy in some Always On workflows to make PS-scripts work more stable
Updated the visualization library
Fixed: Always On objects get undiscovered when any Always On discovery crashes

New SQL Server Replication 2008/2012/2014/2016 MP Features and Fixes

Added support for configurations where computer host names are longer than 15 symbols
Fixed: MonitorDistributorSnapshotFreeSpace fails when being launched against SQL Server 2014 SP2
Fixed: Wrong source detection in logging
Updated the visualization library

New SQL Server Analysis Services 2008/2012/2014/2016 MP Features and Fixes

Added support for configurations where computer host names are longer than 15 symbols
Fixed: AS workflows sometimes crash
Updated the visualization library

New SQL Server Reporting Services 2008/2012/2014/2016 MP Features and Fixes

Added support for configurations where computer host names are longer than 15 symbols
Fixed: Web Service monitors do not support URL reservation https://+:<port>/<ReportServerPage> (protocol is HTTPS)
Updated the visualization library

New SQL Server Dashboards Features and Fixes

Fixed: Tiles content is replaced with question signs after a long period of inactivity

We are looking forward to hearing your feedback.

Additional resources