Released: Public Preview for SQL Server Management Packs Update (6.7.16.0)

We are getting ready to update the SQL Server Management Packs. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final product so much better.

Please download at:

Microsoft System Center Management Packs (Community Technical Preview 1) for SQL Server

Included in the download are Microsoft System Center Management Packs for SQL Server 2008/2008 R2/2012/2014/2016 (6.7.16.0).

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

  • Implemented some enhancements to data source scripts
  • Fixed issue: The SQL Server 2012 Database Files and Filegroups get undiscovered upon Database discovery script failure
  • Fixed issue: DatabaseReplicaAlwaysOnDiscovery.ps1 connects to a cluster instance using node name instead of client access name and crashes
  • Fixed issue: CPUUsagePercentDataSource.ps1 crashes with “Cannot process argument because the value of argument “obj” is null” error
  • Fixed issue: Description field of custom user policy cannot be discovered
  • Fixed issue: SPN Status monitor throws errors for servers not joined to the domain
  • Fixed issue: SQL Server policy discovery does not ignore policies targeted to system databases in some cases
  • Increased the length restriction for some policy properties in order to make them match the policy fields
  • Actualized Service Pack Compliance monitor according to the latest published Service Packs for SQL Server

New SQL Server 2014/2016 MP Features and Fixes

  • Implemented some enhancements to data source scripts
  • Fixed issue: DatabaseReplicaAlwaysOnDiscovery.ps1 connects to a cluster instance using node name instead of client access name and crashes
  • Fixed issue: CPUUsagePercentDataSource.ps1 crashes with “Cannot process argument because the value of argument “obj” is null” error
  • Fixed issue: Description field of custom user policy cannot be discovered
  • Fixed issue: SPN Status monitor throws errors for servers not joined to the domain
  • Fixed issue: SQL Server policy discovery does not ignore policies targeted to system databases in some cases
  • Fixed issue: Garbage Collection monitor gets generic PropertyBag instead of performance PropertyBag
  • Increased the length restriction for some policy properties in order to make them match the policy fields
  • Actualized Service Pack Compliance monitor according to the latest published Service Packs for SQL Server

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.
We are looking forward to hearing your feedback at sqlmpsfeedback@microsoft.com.