New versions of the SQL management packs were released a short while ago links for all of the versions 6.7.31.0 MPs can be found below:
SQL Server
SQL Server 2008/2012 – here
SQL Server 2014 – here
SQL Server 2016 – here
SQL Server Dashboards
SQL Server Dashboards – here
SQL Server Replication
SQL Server 2008 Replication – here
SQL Server 2012 Replication – here
SQL Server 2014 Replication – here
SQL Server 2014 Replication – here
SQL Server Analysis Services
SQL Server 2008 Analysis Services – here
SQL Server 2012 Analysis Services – here
SQL Server 2014 Analysis Services – here
SQL Server 2016 Analysis Services – here
SQL Server Reporting Services (Native Mode)
SQL Server 2008 Replication(Native Mode) – here
SQL Server 2012 Replication(Native Mode) – here
SQL Server 2014 Replication(Native Mode) – here
SQL Server 2014 Replication(Native Mode) – here
New in this version:
Important Notes About This Release
- Please note that we implemented a new alerting rule for SQL Server event #18456 “Login failed” in this release. However, this rule may become rather noisy due to the fact that the target events appear quite frequently in some environments. The rule is enabled by default; thus, if it creates too many alerts in your environment, consider disabling it via the override. The ideal would be to resolve the underlying issues causing the alert but we understand this is not always a priority.
- We are introducing a new monitor in this release (see the first bullet below) based on customer feedback. You have now a better solution for monitoring backups of AG databases.
SQL Server 2008-2016
- Added new “Availability Database Backup Status” monitor in Availability Group to check the existence and age of the availability database backups (this monitor is disabled by default)
- “Database Backup Status” monitor has been changed to return only “Healthy” state for the databases that are Always On replicas, since availability database backups are now watched by the dedicated monitor
- Improved performance of DB Space monitoring workflows
- Added new “Login failed” alerting rule for SQL Server event #18456
- Fixed issue: “Active Alerts” view does not show all alerts
- Fixed issue: DB space monitoring scripts fail with “Cannot connect to database” error.
- Fixed issue: PowerShell scripts fail with “Cannot process argument because the value of argument ‘obj’ is null” error
- Fixed issue: Alert description of “Disk Ready Latency” and “Disk Write Latency” monitors displays the sample count instead of the performance value that was measured
- Fixed issue: Different file location info from “sys.master_files” and “sysfiles” causes error when Availability Group secondary database files are in different path
- Fixed issue: “DB Transaction Log Free Space Total” rules return wrong data
- Introduced minor updates to the display strings
- Deprecated “Garbage Collection” monitor and the appropriate performance rule
- Resource Pool Discovery is disabled by default for pools not containing databases with Memory-Optimized Tables
- “XTP Configuration” monitor now supports different file path types (not only those starting with C:, D:, etc.)
- Fixed issue: “Resource Pool State” view shows incorrect set of objects
- Fixed issue: Invalid group discovery in SQL Server 2016 Always On
- Updated the visualization library
SQL Server Dashboards
- Increased the version number to comply with the current version of SQL Server MPs
SQL Server 2008-2016 Replication
- Added Distributor name caching to Subscription discovery
- Restricted the length of some string class properties
- Improved the internal structure of SQL scripts storage
- Fixed variable types in SQL scripts
- Fixed connectivity issues in SmartConnect module
- Introduced minor updates to the display strings
- Updated the visualization library
SQL Server 2008-2016 Reporting Services
- Reimplemented Instance seed discovery: replaced the managed module with a PowerShell script
- Reimplemented Deployment seed discovery: added a retry policy and improved error handling
- Updated the visualization library
SQL Server 2008-2016 Analysis Services
- Restricted length of some string class properties
- Updated the visualization library
