We are happy to announce that Management Packs for SQL Server 2017 Analysis Services and Reporting Services are released.

Please download at:

Version Agnostic SSAS and SSRS MPs

As you might recall, we introduced version agnostic MPs starting with SQL Server 2017. We are now doing the same for SSAS and SSRS. We understand that with many SQL Server versions in market and with new server releases becoming more frequent, it is becoming harder to manage a separate MP for each server version. We are moving to version agnostic MPs to address this issue. This will be valid going forward. The new MPs will be named SSAS and SSRS 2017+. The ‘+’ in the name indicates that it will be used to monitor SQL Server AS and RS 2017 and the releases that come after that. Current in-market MPs (2008 through 2016) will not be changed and the 2017+ MP cannot be used to monitor older releases.

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.

Release Note

These management packs have been changed so that they now require Microsoft SQL Server 2017+ Core Library of version 7.0.7.0, which is delivered within these management packs as well as within the management pack for Microsoft SQL Server 2017+ of version 7.0.7.0. If you have the Core Library of version 7.0.8.0 or higher installed in your test environment, it will not be possible to completely update the management packs to version 7.0.10.0, because SCOM cannot import a lower version of already installed either .MP or .MPB file. We recommend you entirely delete the CTP version of the management packs for SSRS 2017+ and SSAS 2017+ including the Core Library and then install the current RTM version of them.

SSAS  2017+ MP New Features and Fixes

• Replaced the Core Library in the delivery with the version 7.0.7.0, the version delivered with the most recent RTM version of the management pack for SQL Server 2017+.
• Improved displaying of the SSAS instance version (now shows Patch Level version instead of Version).
• Added missed dependency monitors required to roll up the instance health appropriately.
• Fixed alert for “Partition Storage Free Space” monitor.
• Updated Summary dashboards.
• Updated display strings.

SSRS  2017+ MP New Features and Fixes

• Replaced the Core Library in the delivery with the version 7.0.7.0, the version delivered with the most recent RTM version of the management pack for SQL Server 2017+.
• Updated the monitoring of Memory Consumption and CPU Usage in order to collect performance data for all subprocesses in addition to the main SSRS service process.
• Updated display strings.
• Updated Summary dashboards.
• Fixed minor issues found in the CTP version.

Let’s block ads! (Why?)

SQL Server Release Services