Released: Public Preview for SQL Server Management Packs Update (7.0.5.0) and SSRS Management Pack Update (7.0.6.0)

We are getting ready to update the SQL Server and SQL Server Reporting Services 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

Microsoft System Center Management Pack (Community Technology Preview) for SQL Server 2017+

Microsoft System Center Management Packs (Community Technology Preview) for SQL Server 2008-2016 Reporting Services (Native Mode)

New SQL Server 2008-2012 MP Features and Fixes

  • Updated the “Max worker thread count” data source of the corresponding monitor and performance rule
  • Fixed issue: the “Transaction Log Free Space (%)” monitor does not work
  • Fixed issue: in some environments, DB Space workflows fail when a secondary database is non-readable

New SQL Server 2014-2016 MP Features and Fixes

  • Updated alert severity in some monitors
  • Updated the display strings
  • Updated the “Max worker thread count” data source of the corresponding monitor and performance rule
  • Fixed issue: the “Transaction Log Free Space (%)” monitor does not work

New SQL Server 2017+ MP Features and Fixes

  • Implemented an ability to monitor SQL Server Cluster instances locally; formerly, it was possible only in Agentless and Mixed modes
  • Added the SSIS monitoring
  • Added the “Exclude List” property in DB Engine Discovery in order to filter instances, which are not subject to monitoring
  • Added the “Exclude List” property in DB Discovery in order to filter databases, which are not subject to monitoring
  • Implemented a feature: both “Exclude List” properties support usage of the asterisk character to make the filter more flexible. E.g. “*temp” is used to exclude instances/databases ending with “temp” and having anything in the beginning.
  • Added the “Computers” view
  • Added the “ClusterName” property to the AG class and updated AG alerts in order to display the property within
  • Updated the “SP Compliance” monitor in order to support the Modern Servicing Model for SQL Server: the monitor will check build number instead of Service Pack number
  • Updated the “SPN Status” monitor so that it requires only a single SPN record when only TCP/IP is enabled and the instance is the default one
  • Updated the “Database Backup Status” monitor: it is disabled by default now
  • Updated the DB Space monitors so that their alert descriptions include the actual value of space available
  • Updated the “Configuration Security” section in the guide
  • Fixed issue: the “Database Health Policy” monitor ignores the “Critical” state (on Windows only)
  • Fixed issue: the “Alert severity” property of the “DB File Free Space Left” monitor has incorrect Default Value
  • Fixed issue: the “DB Filegroup Fx Container” rollup monitor has an alert parameter with a wrong value within
  • Fixed issue: “Resource Pool Memory consumption” monitor may not change its state to “Critical” for the “default” resource pool
  • Fixed issue: “Number of Samples” parameter of “Resource Pool Memory consumption” alert displays incorrect data
  • Fixed issue: missed image resources in the SQL Server 2017+ Core Library

New SSRS 2008-2016 MP Features and Fixes

  • Added support for cases when a connection string of the SSRS instance to the SSRS Database is not in the “MachineName\InstanceName” format; e.g. “<IP Address>,<Port Number>” or “(local)”, etc. Such connection strings are fully supported for default SQL Server instances hosting the SSRS Database. If the instance is named, workflows targeted at the SSRS Instance object work properly, but those targeted at the Deployment object cannot work, as there is no possibility to learn the FQDN of the server.
  • Updated the Deployment Seed discovery so that it does not check if the SQL Server instance hosting the SSRS Database is running

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.