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

  • Article

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 (7.0.3.0).

Please read if you have more than 1500 database files

When a SQL Server instance has about 1500 or more database files, the Data Files Discovery generates an output, which exceeds the SCOM Agent 4 MB threshold, and then the discovery fails. We added a new "Discover DB Group Seed" discovery to make the MP monitor such instances smoothly. If the data files in your environment cannot be discovered due to the 4 MB threshold, just enable the new discovery. Note that you should not enable it unless you face the problem described above.

New SQL Server 2008-2012 MP Features and Fixes

  • Fixed issue: Agent tasks do not have any SQL MP Run as Profile mapped
  • Implemented caching of data received from WMI to reduce the number of requests to WMI
  • Changed ps1 data source scripts to avoid the "Pipe is being closed" error
  • Disabled Latency Disk Read/Write performance rules by default
  • Added the actual value of available disk space in DB Space monitoring alerts
  • Updated some of the display strings
  • Increased SQL Command timeout in the data source scripts up to 60 seconds (previously it was 30 seconds)

New SQL Server 2014-2016 MP Features and Fixes

  • Added a new discovery for dealing with cases when an SQL Server instance has a vast of database files (near 1500 and more); it is disabled by default
  • Implemented caching of data received from WMI to reduce the number of requests to WMI
  • Improved the output of discoveries of Database Filegroups and Files so they do not contain unnecessary data
  • Changed ps1 data source scripts to avoid the "Pipe is being closed" error
  • Disabled Latency Disk Read/Write performance rules by default
  • Added the actual value of available disk space in DB Space monitoring alerts
  • Updated some of the display strings
  • Increased SQL Command timeout in the data source scripts up to 60 seconds (previously it was 30 seconds)

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.