Released: Public Preview for SQL Server Management Packs Update (6.7.34.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) for SQL Server

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

New SQL Server 2008-2012 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Added debug information to Always On monitoring scripts
  • Disabled the alerting rule for event #18456 by default
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks

New SQL Server 2014 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Implemented “MSSQL 2014/16: HTTP Storage: Avg. Bytes/Transfer” performance rule
  • Added debug information to Always On monitoring scripts
  • Disabled the alerting rule for event #18456 by default
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks

 New SQL Server 2016 MP Features and Fixes

  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Added debug information to Always On monitoring scripts
  • Implemented “MSSQL 2014/16: HTTP Storage: Avg. Bytes/Transfer” performance rule
  • Enabled Memory-Optimized workflows for all editions of SQL Server 2016 by default, so far as all editions now support Memory-Optimized Data since SP1
  • Disabled the alerting rule for event #18456 by default
  • Optimized ProbeAction for User Resource Pool Memory workflows
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks
  • Fixed issue: “XTP Configuration” monitor is in healthy state when XTP filegroup container and the transaction log are placed on different volumes of a physical disk
  • Fixed issue: Incorrect publishers’ names for SSIS EventCollection rules (SQL2016)
  • Fixed issue: GetSQL2016DBEngineWinServState.js crashes when getting neither “true” nor “false” as the second parameter (CheckStartupType)

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.